Using the SQL LIKE operator with the UPPER() syntax

Question

I am trying to use the LIKE operator in my query as follows:

mysql> select cat_title from category where cat_title like '%Indian%Restaurant%';
+--------------------+
| cat_title          |
+--------------------+
| Indian_Restaurants |
+--------------------+
1 row in set (2.59 sec)

However, since I want to do a case insensitive search, I am trying:

mysql> select cat_title from category where UPPER(cat_title) like UPPER('%Indian%Restaurant%');
Empty set (2.83 sec)

Why is the second query not working?

score 1 · Answer 1 · edited May 23 '17 at 11:57

1

Most likely the collation on the cat_title column is case insensitive. Use

... cat_title LIKE '%Indian%Restaurant%' COLLATE utf8_bin

Using the SQL LIKE operator with the UPPER() syntax

1 Answers1