Get Collection from complicated query

Question

For example, I need to get city name in search field. City, as Model, has its own name and region string columns. I need to get Collection in order like:

1. Cities with name ilike input value
2. Cities with region ilike input value
3. Other cities.

Answer 1

City::where(['name'=>'ilike','region'=>'ilike'])->get() - It it is equivalent to - Select * from cities where region = 'ilike' and name = 'ilike'
or maybe you mean this 
1.City::where('name','ilike')->get() ;
2.City::where('region','ilike')->get();
3.City::where('region',"!=",'ilike')->where('name',"!=",'ilike')->get();