MYSQL like 模糊查询
2018-09-28 本文已影响0人
Dabbie
表A： complication
表B：COM_TYPE
结果，计算B表类型对应A表条数
select b.TYPE,count(*) FROM
complication A,(select TYPE FROM COM_TYPE) B
WHERE A.CASE_TYPE LIKE CONCAT('%',b.TYPE,'%')
group by b.TYPE
表A： complication
表B：COM_TYPE
结果，计算B表类型对应A表条数
select b.TYPE,count(*) FROM
complication A,(select TYPE FROM COM_TYPE) B
WHERE A.CASE_TYPE LIKE CONCAT('%',b.TYPE,'%')
group by b.TYPE
