title: MySQL SELECT LIKE or REGEXP to match multiple words in one record
body: <p>The field <code>table</code>.<code>name</code> contains 'Stylus Photo 2100' and with the following query</p>
  
  <pre><code>SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus 2100%'
  </code></pre>
  
  <p>I get no results. Of course i would if i searched</p>
  
  <pre><code>SELECT `name` FROM `table` WHERE `name` LIKE '%Photo 2100%'
  </code></pre>
  
  <p>How can I select the record by searching 'Stylus 2100' ?</p>
  
  <p>Thanks </p>