title: MySQL: What is a reverse version of LIKE?
body: <p><em>LIKE</em> operator in MySql is used to find rows that contain our query text, for example:</p>
  
  <pre><code>select name from user where name like "%john%"
  </code></pre>
  
  <p>which will return <code>John Smith</code>, <code>Peter Johnson</code> etc.</p>
  
  <p>What if I need the opposite - to find rows that are <em>CONTAINED</em> in our query text? For example I give it <code>John Smith and Peter Johnson are best friends</code> and want it to find me all names from the table that could be found in this string.</p>
  
  <p>How to do that?</p>