title: SQL like search string starts with
body: <p>Learning SQL. Have a simple table games with field title. I want to search based on title. If I have a game called <code>Age of Empires III: Dynasties</code>, and I use <code>LIKE</code> with parameter <code>Age of Empires III: Dynasties</code>, everything works fine, the search returns the record with that name. But if I search with <code>Age of Empires III</code>, it doesn't return any records:</p>
  
  <pre><code>SELECT * from games WHERE (lower(title) LIKE 'age of empires III');
  </code></pre>
  
  <p>This doesn't return anything. Should I be using something else instead of <code>LIKE</code>?</p>
  
  <p>I am using MySQL.</p>