how can I delete multiple mysql entries that are in the same table?
Thanks, JOhn
delete from the_table where some_field = some_value
will delete all the entries with matching some_field.
you could also replace the = with like and use %.
Delete from table WHERE field LIKE 'j%' will delete everything starting with a J.
I should have been a little clearer. I just want to remove all but one of the entries. so the "multiple" part is just back down to single.
John
