title: Deleting entries from table based on count?
body: <p>I have a database with users. It contains a row called uplink. i need help with deleting users based on their points. the uplink table is updated when each time the user gain a point. the uplink table writes the username in it with auto increment id row. i can see the points of the user by executing
  the following commands. </p>
  
  <pre><code>SELECT count(*) FROM media WHERE username='username'
  </code></pre>
  
  <p>i need to delete the users who have point less than 1</p>
  
  <p>i want to do something like</p>
  
  <pre><code>DELETE FROM media WHERE uplink HAVING COUNT(*) &lt; 1
  </code></pre>
  
  <p>Need a solution</p>
  
  <p>I am trying on a linux server with phpmyadmin installed. the table name was media.</p>