[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;