title: sql/mysql subtract a set of keywords from results
body: <p>I have a table <code>MOVIES</code> that has these fields: <code>genre</code> and <code>classification</code>. I am searching for all the Action movies but NOT the animated-action ones.</p>
  
  <p>Each row contains all the classifications for example a row looks like:</p>
  
  <pre><code>Action,thriller,animated-action,movie
  </code></pre>
  
    
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM movies 
  WHERE $email_filter 
  concat( movies.genre,  movies.classification) like '%Action%' 
  AND NOT LIKE '%Animated-Action%' 
  </code></pre>
  
  <p>This is what I tried. It returns 0 results. Any help would be appreciated thank you</p>