Mysql: How To Remove Duplicate Entries?

I want to remove all duplicate entries.
For example, I have 4 things w/ the name="bubble". I want only 1 to remain.

 

Does it matter which one you keep?

 

not really.
I guess if i had to choose then the one with the lowest ID number (another field...) but it doesn't really matter.

 

if you mean selecting unique values only, then i suggest you use the SELECT DISTINCT sql command.

if you actually mean cleaning up your table, maybe you can also use the SELECT DISTINCT command to select distinct records into a dump file and then restore that dump file into a new table.

 

but wouldn't SELECT DISTINCT totally ignore the ones that are duplicates? (not just choose 1...)

and how would I do SELECT * where word is distinct..

thanks!

 

distinct should work and i suggest using the IGNORE command to prevent this from happening again

 

Ok... I see what i wanted is to select the whole row when 1 field is distinct.
Anyway, here it is:
select *, count(FIELD) from TABLE group by FIELD having count(FIELD)>=1;

thanks for everyones help.