title: MySQL - How to delete rows where column does not contain certain values?
body: <p>I'm trying to delete all rows where a specific column does not contain certain strings. 
  Like this:</p>
  
  <pre><code>DELETE * FROM table
  WHERE Disease NOT LIKE (Malaria, HIV, E. coli O157);
  </code></pre>
  
  <p>I get this error:
  <strong>#1064 - You have an error in your SQL syntax; near '* FROM table WHERE Disease NOT LIKE (Malaria' at line 1</strong></p>