select *
from test
where p_id in ( select p_id from test where p_ids LIKE '%111%' and id = 222)
2021.06.25 mysql查询：将查询出来的结果作为条件继续查询
Tags: mysql
select *
from test
where p_id in ( select p_id from test where p_ids LIKE '%111%' and id = 222)