ccdavies ccdavies - 5 months ago 14
MySQL Question

Search and then delete from two tables

I have two tables which have member data (linked with 'member_id' column)

I need to search for all records where the

column ends in '.pl'. I then need to delete all records from the two tables for this (based on the 'member_id').

Is it possible to complete this in one SQL statement?

SELECT member_id
FROM exp_members
WHERE email LIKE ''

delete t1, t2
from exp_members t1
join table2 t2 on t1.member_id = t2.member_id
where LIKE ''