INSTR() with caseless?

[Anon]

I'm programming a search function in a table. However, I need a function to perform match string with caseless. The one I used was INSTR() but this one is casesensitive. Is there any other way to tell if a $text is in a field of a record no matter about the case of every characters.

[Anon]

You could do it in your SQL statement with LIKE

e.g. select * from tab where text_field like "%text_to_look_for%";

if you are using MySQL it will case insensitive.

NB. Doing a %text% search will not use any indicies so may not be the best way to go.

HTH
Justin