title: How to update multiple values in one column using one sql query?
body: <p>I am working with a huge user database and there are around 200 user emails I want to set to an empty value, is there a easy way to remove them all in one query? here is a simple idea of what the table looks like.</p>
  
  <p>(also as there a lots of email, I dont want to looks for all the ids, i only have the emails to work with)</p>
  
  <pre><code> column1 | column2 | customerEmail | column4
  1                    email1
  2                    email2
  3                    email3
  </code></pre>
  
  <p>Here is what i was going for but i received syntax error when using it for multiple values.</p>
  
  <pre><code>UPDATE `email-database`
  SET customerEmail = ''
  WHERE customerEmail = 'test@gmail.com', 'test2@gmail.com', 'test3@gmail.com';
  </code></pre>