ccdavies ccdavies - 3 months ago 6
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

email
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 '%.pl'

Answer
delete t1, t2
from exp_members t1
join table2 t2 on t1.member_id = t2.member_id
where t1.email LIKE '%.pl'
Comments