In such searches, MySQL will ignore the indexes, convert the values held by the specified column in each row to UCASE and then perform the search for the given sample text. The easiest way out of such ...

If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged about MySQL indexes. I’ve already told you about the nuances of indexes in MySQL, vanilla B-Tree indexes, ...

Step 1 : Create a sample mysql table, add some data into it. Step 2 : Make sure that your database table uses MyISAM storage engine, if not then use below query to alter your table. ALTER TABLE ...