mysql包含列值_mysql – 检查一列的值是否包含另一列的值
分类:SQL
from https://blog.csdn.net/weixin_32417571/article/details/113605031
select p.id, p.pkg
from package p
inner join ad_frameworks adf on p.pkg like CONCAT('%', adf.path_fragment, '%')
--group by p.id, p.pkg
或者你指出的
select *
from package p
inner join ad_frameworks adf on LOCATE(adf.fragment, p.pkg) > 0
要么
select *
from package p
inner join ad_frameworks adf on INSTR( p.pkg,adf.fragment) > 0
要么
select *
from package p
inner join ad_frameworks adf on POSITION(adf.fragment IN p.pkg) > 0
要么
select *
from package p
inner join ad_frameworks adf on REPLACE(p.pkg, adf.fragemnt, '') <> p.pkg