title: SQL query - match any part of string
body: <p>I have a table the contains a VARCHAR column called - DOC_NAME.
  I would like to query this column for any string matches, partial matches are accepted as well.</p>
  
  <p>For example, the column contains:</p>
  
  <p>"How dangerous Virus and Spyware attach on the system – Techicode"</p>
  
  <p>If I search for "virus spyware" I get no results.
  I don't want to search each word separately, as this might return irrelevant results.
  Also, I want to search for 'keywords' and not necessary the whole string.</p>
  
  <p>I've tried the following options:</p>
  
  <p><code>select * from docs where DOC_NAME like '%virus spyware%';</code></p>
  
  <p>I've also tried:</p>
  
  <pre><code>SELECT * FROM docs WHERE DOC_NAME LIKE CONCAT('%','virus spyware','%')
  </code></pre>
  
  <p>But as I've mentioned, I don't any results back.</p>
  
  <p>I there a query I can use that will return a value?</p>
  
  <p>Thanks in advance.</p>