title: SELECT MySQL field that contains a substring
body: <p>Using LIKE is very common in MySQL. We use it like this: <code>WHERE field LIKE '%substring%'</code>. Where we have a substring and field has full string. But what I need is something opposite. I have substrings in field. So, I want that row which contains a substring of my string. Suppose the table is:</p>
  
  <pre><code>----+-------------------
   id | keyword
  ----+-------------------
    1 | admission
  ----+-------------------
    2 | head of the dept
  ----+-------------------
  </code></pre>
  
  <p>and I have a string from user: <code>Tell me about admission info</code>. I need such a MySQL query that returns <code>admission</code> as this is a substring of user string. Something like:</p>
  
  <pre><code>SELECT keyword FROM table WHERE (keyword is a substring of 'Tell me about admission info')
  </code></pre>
  
  <p>thanks in advance.</p>