Posted by Mad Hatter on 11/11/06 00:00

>>
>> $q="SELECT id FROM $dbfilenames WHERE type='b' AND LOWER(name) LIKE
>> '%$se%'";
>>
>
> Odd, I would have guessed that LOWER was redundant in this context,
> because only BOOLEAN MODE searches are case sensitive in MySQL. Can you
> echo the query so we can see exactly what's being submitted?

I did in the original post. It's shown above. $se is pulled in from a form.
I've tried it on a few servers. It works properly on all except one and I
don't have access to php.ini to see what's different. Basically what I'm
trying to do, when someone enters Fred in the form it'll find all entries
with fred in it in any case. So, Fred, fred, frederik, freda, FREDA etc
would all be found. It works perfectly on all except the one server :-(

[Back to original message]