Posted by Mad Hatter on 11/06/06 22:45

Hi

I'm trying to find data in a database. The data is in mixed case. I'm
trying to find all occurances of a particular string but the string isn't
in the same case all the time. For example I could be looking for the word
'fred' but in the database it could be 'Fred', 'FRED', 'fred' etc. I'm
using the following which seems to work on some servers but not others.

$q="SELECT id FROM $dbfilenames WHERE type='b' AND LOWER(name) LIKE
'%$se%'";

Any thoughts as to why this works on some and not on others and a possible
work around for it?

[Back to original message]