title: How to delete from select in MySQL?
body: <p>This code doesn't work for MySQL 5.0, how to re-write it to make it work</p>
  
  <pre><code>DELETE FROM posts where id=(SELECT id FROM posts GROUP BY id  HAVING ( COUNT(id) &gt; 1 ))
  </code></pre>
  
  <p>I want to delete columns that dont have unique id. I will add that most of the time its only one id(I tried the in syntax and it doesnt work as well).</p>