title: Using OR in LIKE Query in MySQL to compare multiple fields
body: <p>I always thought that you could use <code>OR</code> in a <code>LIKE</code> statment to query things in MySQL.  So, if I wanted to compare multiple fields in a row to 1 keyword or term:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE Column1 OR Column2 LIKE '%keyword%'; 
  </code></pre>
  
  <p>and if I had an array of words to compare:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE Column1 OR Column2 LIKE '%keyword1%' 
  AND Column1 OR Column2 LIKE '%keyword2%';
  </code></pre>
  
  <p>I don't believe that syntax is correct, however.  Is there an efficient method of writing this aside from something like:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE Column1 LIKE '%keyword1%' OR Column2 LIKE 
  '%keyword1%' AND Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%';
  </code></pre>
  
  <p>Am I going about this correctly?</p>