Case insensitive db searches

[Anon]

Hi all

I am a bit of a mysql beginner trying to tweak a search engine.

I want my searches to be case-insensitive, but MySQL seems to want to do sensitive matching only. How can I force it to do the former?

I am using a statement of the form

SELECT blah FROM blah WHERE blah IN ($querywords)

where $querywords is an array holding the words the user typed in the search box.

[Anon]

Hi,

You must do something like that:

SELECT blah FROM blah WHERE UPPER(blah) IN ($querywords)

where in your $querywords array you already put the words in capital letters...

Cheers,

Catalin

[Anon]

Thankyou very much Catalin - I have found the online MySQL manuals at www.mysql.com to be very hard to locate things in (not very impressed with their search engine)... so you have saved me a lot of time. Thankyou!

[enterume]

hi, I got a search function in my site, which let the user choose to search in 'case-sensitive' and case-insensitive, how?

I am using 'like' in my sql statement.

Thanks.