title: Using the SQL LIKE operator with the UPPER() syntax
body: <p>I am trying to use the LIKE operator in my query as follows:</p>
  
  <pre><code>mysql&gt; select cat_title from category where cat_title like '%Indian%Restaurant%';
  +--------------------+
  | cat_title          |
  +--------------------+
  | Indian_Restaurants |
  +--------------------+
  1 row in set (2.59 sec)
  </code></pre>
  
  <p>However, since I want to do a case insensitive search, I am trying:</p>
  
  <pre><code>mysql&gt; select cat_title from category where UPPER(cat_title) like UPPER('%Indian%Restaurant%');
  Empty set (2.83 sec)
  </code></pre>
  
  <p>Why is the second query not working?</p>