字段包含多个数据的SQL

作者mskkingtake

5 月 31, 2023

SELECT bac.st_superior_ids
FROM bpq_attachment ba
inner join bpq_att_catalog bac on ba.st_save_path = bac.id
where 1=1
and CONCAT (‘,’,bac.st_superior_ids,’,’) REGEXP ‘,(9c3ef689d626c39ef2e339e4d29c791a|f7bf9e5c35bc4bd5b07ea4b97e93e0ce|9),’;