title: Separating keywords by space and searching MySQL database
body: <p>I am working with PHP and MySQL. I'll provide a simple table below:</p>
  
  <pre><code>------------------------------------------------------
  |  id |                    text                      |
  ------------------------------------------------------
  |  1  | The quick brown fox jumped over the lazy dog | 
  ------------------------------------------------------
  </code></pre>
  
  <p>I'd like users to be able to search using keywords separated by spaces. I've got a simple SQL query for the above which is <code>SELECT * FROM table WHERE text LIKE %[$keyword]%</code> which means if  I search for "The quick fox", I won't get any results. Is there a way to separate the keywords by spaces so if I search for "The quick fox", it will run 3 searches. One for "The", one for "quick", and one for "fox" - removing all white spaces. Though it should only display one result since it all belongs to the same row instead of 3 since all 3 keywords matched the data in the row.</p>
  
  <p>What's the best way to do this? All suggestions to do this better are always welcome. Thanks!</p>
  
  <p>[EDIT]</p>
  
  <p>Just thought of this now, would separating the keywords by comma (,) be a better option?</p>