title: MySQL query String contains
body: <p>I've been trying to figure out how I can make a query with MySQL that checks if the value (string <code>$haystack</code> ) in a certain column contains certain data (string <code>$needle</code>), like this:</p>
  <pre><code>SELECT *
  FROM `table`
  WHERE `column`.contains('{$needle}')
  </code></pre>
  <p>In PHP, the function is called <code>substr($haystack, $needle)</code>, so maybe:</p>
  <pre><code>WHERE substr(`column`, '{$needle}')=1
  </code></pre>