Search This Blog

Tuesday, July 26, 2011

[Mysql] Case In-Sensitive Search

By default MySql performs a case sensitive search in order to perform case IN-sensitive search you need to use COLLATE option as shown below

select id from my_table where id like "%X%" COLLATE latin1_general_cs;

No comments:

Post a Comment