title: MYSQL Query to find matches LIKE
body: <p>I have a tabel with 2 rows. ID and FILTER.</p>
  
  <p>In the FILTER row i have added The.White.Tiger.</p>
  
  <p>Running this query :</p>
  
  <pre><code>SELECT id
  FROM filter
  WHERE filter LIKE CONCAT( '%', 'The.White.Tiger', '%' )
  LIMIT 0 , 30
  </code></pre>
  
  <p>Returns 1 result, the ID.</p>
  
  <p>But i need it to find a result nomater whats els is in the title.</p>
  
  <pre><code> SELECT id
   FROM filter
   WHERE filter LIKE CONCAT( '%', 'The.White.Tiger.At.My.House', '%' )
   LIMIT 0 , 30
  </code></pre>
  
  <p>This returns no result, but i need to make the query so that it dos still find it.
  Any ideer on how to do that?</p>
  
  <p>As long as the string thats are in FILTER row is in the start of the title string it should ignore the rest
  Tabel struckture</p>
  
  <pre><code>1   id  int(11)         AUTO_INCREMENT          
  2   filter  varchar(255)    latin1_swedish_ci       
  </code></pre>