title: MySQL error happens: Operand should contain 1 column(s)
body: <p>I'm currently self-studying to become a programmer and I've run into a little snag and can't seem to figure out why this particular code doesn't work...</p>
  
  <p>I'm trying to create a list of movie titles that do no contain the word 'kill' or 'blood' in the title name and are of the genre thriller or horror (griezel in dutch :p).</p>
  
  <p>For this I'm using the code below</p>
  
  <pre><code>SELECT filmId, titel, genre
  FROM films
  INNER JOIN genres ON films.genreId = genres.genreId
  WHERE titel NOT LIKE ('%blood%', '%kill%')
    AND genre IN ('thriller', 'griezel')
  </code></pre>
  
  <p>When I try to execute this code is get an error message saying the following </p>
  
  <blockquote>
    <p>Operand should contain 1 column(s)</p>
  </blockquote>
  
  <p>Any help would be much appreciated!</p>
  
  <p>Thanks in advance ;)</p>