Removing where count =1?

[krohnathlonman]

$link = $DB_site->query("select ref
, count(*) as refcount
from amartinref
group by ref
ORDER BY refcount DESC");

Basically my ref log has gotten large enough that I can't run it within the allocated amount of time anymore. How would I do a query to eliminate any URL's that are in the table say less than 3 times?

[guelphdad]

Is your table indexed? if not you will be able to speed up your queries significantly.

To delete with less than three then do something like:

delete from amartinref where ref IN (
select ref
from amartinref
group by ref
having count(ref) < 3
)