[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.