title: MySQL multiple keyword search algorithm
body: <p>Can anyone give me ideas or recommendations on how to build a multiple search algorithm? </p>
  
  <p>For example, I have a products table in my MySQL database, and I'd like to be able to search for multiple keywords in the <code>title</code> and <code>description</code> columns. These keywords could contain multiple words, for example: "blue electric bosch toaster machine".</p>
  
  <p>What would be the optimal method for accomplishing this? </p>
  
  <p>So far I was thinking about:
      1. Using the LIKE "%$keywords%" in MySQL
      2. Spliting the keywords based on whitespace, and searching on each individual word, but I think it's best that I search for the whole keyword.</p>