Union of two queries for one table

[eluser]toopay[/eluser]
If you use 'LIKE' statement, thats mean your database will only returns match result. You can't get "searched result" and "all result" in a single query. Your option is either, (1)execute two queries or (2)select all of your record, unpack it, grouping it into two different array in your model, pack it again, then send it to your controller.