Bug #10225 Like is not case-insensitive as per the documentation
Submitted: 28 Apr 2005 5:53 Modified: 28 Apr 2005 6:32
Reporter: Todd Deshane Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.10 OS:Linux (Linux and Windows)
Assigned to: CPU Architecture:Any

[28 Apr 2005 5:53] Todd Deshane
A.5.1 Case Sensitivity in Searches

" By default, MySQL searches are not case sensitive"

We tried the query:

 SELECT * from tableName WHERE something LIKE '%T%'

With a value of 'title' for example in the something field

then trying:

 SELECT * from tableName WHERE something LIKE '%t%'

returns the rows that have 'title' in them

We also tried changing the LIKE to 'T%'

and still no results.

How to repeat:
search for a field in the wrong case...
search for a field in the right case...

Suggested fix:
should be case-insensitive.  It is not czech or BINARY.
[28 Apr 2005 6:32] Hartmut Holzgraefe
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Please add a reproducable test case script