title: MySQL query to filter records containing any of the words in search string
body: <p>I have to develop a simple search page that matches search string with field in MySQL table.</p>
  
  <p>Assume database table is 'records' and field in consideration is 'record_title'. Also say following are the 'record_titles' in rows.</p>
  
  <p>word1 word2<br/>
  word1 word3 word4<br/>
  word5 word2 word1<br/>
  word6<br/></p>
  
  <p>Now in search form, say user submit search terms for example 'word1 word7' , 'word1', 'word1 word5', 'word1 word2' etc, it should return recordtitles having at least one of words in search term. It should not take search string as substrings, for example if search term is 'word' it should not return any of the records in above record set.</p>
  
  <p>I tried with following, but it sometimes do not match single words.</p>
  
  <pre><code>MATCH(`recordTitle`) AGAINST ('+word1 +word2' IN BOOLEAN MODE);
  </code></pre>
  
  <p>How can it (or another solution) can be used to select records containing at least one word matching.</p>
  
  <p>Thank you.</p>
  
  <p>GUIR</p>