title: SQL SELECT where column CONTAINS substring
body: <p>I have a database containing all usernames. Now, I have a page where I can search for an user. At the moment I use the following SQL: </p>
  
  <pre><code>SELECT uid, username, id, status 
  FROM users 
  WHERE `username` LIKE &lt;search string&gt;
  </code></pre>
  
  <p>Now, I have a record with the username <code>Hattorius</code>. But when I use that SQL syntax, and search for <code>hatt</code>. It doesn't give any results. How can I still make this work?</p>
  
  <p>I searched some around, but nobody really had an answer to this. </p>