mysql查找A字段含有XXX的且B字段重复出现的数据。

Question

请教一下。。

这条是查询qrcode表 ord字段重复数据mysql命令

select * from qrcode
where ord in (select orderno from qrcode group by ord having COUNT(*)>1)

我想改成查找remark字段内含有“系统自动充值” 且ord字段的重复数据。要怎么改。

Answer 1

select * from qrcode
where remark like "%系统自动充值%" and ord in (select orderno from qrcode group by ord having COUNT(*)>1)