title: MySQL query with count and deleting the results
body: <p>I have a list of all the zip codes in the united states. I need to delete the zip codes which do not appear in more than one county. </p>
  
  <p>I have created the below query which is able to pull out all the zip codes I do not need, but now I need to delete them. </p>
  
  <pre><code>SELECT zipcode, COUNT(countyname) FROM enrollmy_healthr.`table 10`
  group by zipcode having count(zipcode)&gt;1;
  </code></pre>
  
  <p>Thank you in advance for any assistance you may have. </p>
  
  <p>Regards,</p>