title: Why is an index not used on a LIKE query with wildcards?
body: <p>Although the Title column was added as index by using the following query:</p>
  
  <pre><code>ALTER TABLE Recipe ADD INDEX Title_idx (Title)
  </code></pre>
  
  <p>MySQL doesn't use that index for this query:</p>
  
  <pre><code>SELECT * FROM Recipe
  WHERE Title LIKE '%cake%';
  </code></pre>
  
  <p>I used the <code>EXPLAIN</code> keyword and the key field is <code>NULL</code>.</p>
  
  <p>How to solve it? I have to improve that query.</p>