Case insensitive search in MySQL

In MySQL I use the LIKE syntax in a SELECT ... WHERE query to look for a name the user submits.

However if the table contains the name "TEST", and the user searches for "test" or "Test", it doesn't return it.

If the user submitted "es" the like part would actually be:

LIKE '%es%'

Any way I can make such a search case-insensitive?

Try this:

SELECT * FROM test_table WHERE field REGEX "[eEsS]"

It should work.
HTH

inkel

update mysql. if i remember correctly the search behavior has changed with the new stable release 3.23.

when i tested this on my system running 3.23 searches using LIKE '%search term%' are case insensitive.

Thanks to both of you. It's working now!

Yay. 🙂