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'

回答1:

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

回答2:

Delete from Members where Member_id = (SELECT member_id
FROM exp_members 
WHERE email LIKE '%.pl')