lowercase comparisons

[hexa2k9]

On MySQL the following Query is possible:
SELECT * FROM table WHERE LOWER(field) = 'stringtomatch';

I personally use that A LOT on some webapps .. is there a way for this kind of comparison on idiorm as well? ->select('LOWER(field)', 'stringtomatch') isn't working for me.

The same is for other things like transforming a datetime to a timestamp using UNIX_TIMESTAMP(field).

[j4mie]

Hi,

This is a perfect use case for the where_raw method:

ORM::for_table('table')
    ->where_raw('LOWER(field) = ?', 'stringtomatch')
    ->find_many();

[j4mie]

Oops, forgot to close