从两个表中搜索然后删除

2022-01-05 00:00:00 sql mysql phpmyadmin

我有两个包含成员数据的表(与member_id"列链接)

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

我需要搜索 email 列以.pl"结尾的所有记录.然后，我需要为此删除两个表中的所有记录(基于member_id").

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').

是否可以在一条 SQL 语句中完成此操作?

Is it possible to complete this in one SQL statement? 

SELECT member_id
FROM exp_members 
WHERE email LIKE '%.pl'

推荐答案

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

相关文章