I have MySQL 3.X. Is there any way to quickly delete records in one table where it's email matches the email of records in another table?
I can do this via PHP but it is too slow when I have a table of 1 million records and the other has more than 2 million.
Use phpMyAdmin, or run a query on your server, it shouldnt be any slower then writing a quick script
run your query on the source table, then store the email addresses in a varibable...or an array
"DELETE * FROM table WHERE email='$emails'"
3.x does not support subselects in a DELETE, so you are left with either using a script or doing several queries.
