Help with CI active record and like statement

[eluser]CroNiX[/eluser]
[quote author="John_Betong" date="1252652832"] 
Whoops: misread the question.

Please ignore
 
 
 
edit:
 
 
Ok, I will try again.
 
Try Google and search for "MySql like case-sensitive" for a complete explanation.

In a nutshell then using LIKE maybe case-sensitive depending on the COLLATION of your tables.
 
 
 [/quote]
Yes I know...thats why Im forcing it to lowercase because the search string is lowercase and Im working with multiple databases in multiple formats. Just easier to force to lower...