title: How can I search (case-insensitive) in a column using LIKE wildcard?
body: <p>I looked around some and didn't find what I was after so here goes.</p>
  
  <pre><code>SELECT * FROM trees WHERE trees.`title` LIKE  '%elm%'
  </code></pre>
  
  <p>This works fine, but not if the tree is named Elm or ELM etc...</p>
  
  <p>How do I make SQL case insensitive for this wild-card search?</p>
  
  <p>I'm using MySQL 5 and Apache.</p>