Help with CI active record and like statement

[eluser]CroNiX[/eluser]
[quote author="Aken" date="1252656094"]You can put LOWER(name) in place of your table name and it should generate just like the example you added. Oh, and FYI - in your code example, you have 'after' selected in your third parameter of the like() function. This will generate 'some_var%'. If you want to search both ways, you can omit the third param, or change it to 'both'.

Code:

$search_name = 'search_name';

$this->db->select('name')
    ->like('LOWER(name)', $search_name)
    ->get('users');

// GENERATES: SELECT `name` FROM (`users`) WHERE LOWER(name) LIKE '%search_name%'

[/quote]
Yes, Im using 'after' because its for an autocompleter. Thanks for the info, I swear I tried that like statement you posted...maybe I did something else wrong but its working now.