Order by Appending about codeigniter-base-model

[shayhurley]

this should work:

$this->remote_jobs->order_by('field_to_order_by', 'ASC')->get_many_by($jobs_params);

[adeelmughal4u]

Thanks, it works. 👍

How I will use WHERE LIKE clause for fetching records from table based on this WHERE LIKE?

[willpower232]

It doesn't look like this is implemented currently.

You probably want to copy the order_by function (https://github.com/jamierumbelow/codeigniter-base-model/blob/master/core/MY_Model.php#L747) into a new function for where_like and reference the codeigniter documentation (https://codeigniter.com/user_guide/database/query_builder.html#looking-for-similar-data)