从两个表中搜索然后删除 [英] Search and then delete from two tables

问题描述

我有两个包含成员数据的表(与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'

这篇关于从两个表中搜索然后删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！