title: Querying using multiple LIKEs from same column?
body: <p>My database is listing Jobs. I want a user to be able to query jobs from a particular industry but chose as many work-types from the <code>type</code> column as they want, eg:</p>
  
  <pre><code>SELECT * FROM `rec_jobs` 
  WHERE `industry` LIKE '%Security%' AND 
     (`type` LIKE '%Full-Time%' OR 'type' LIKE '%Part-Time%' OR 'type' LIKE '%Casual%' OR 'type' LIKE '%Contract%');
  </code></pre>
  
  <p>This should return something like:</p>
  
  <blockquote>
    <p><strong>ID - Industy - Type</strong></p>
    
    <hr>
    
    <p>1 - Security - Part-Time</p>
    
    <p>2 - Security - Full-Time</p>
    
    <p>3 - Security - Casual</p>
    
    <p>4 - Security - Full-Time</p>
  </blockquote>
  
  <p>etc.</p>
  
  <p>but it is not working as expected - I dont get any SQL errors or any results (though I know rows exist).</p>
  
  <p>Does anyone know a better way of achieving this (or the correct terminology to search in Google)?</p>