解决字符串不能 select ... where in ()的问
2019-03-12 本文已影响0人
尼尔君
/**
shop_brand :
brand_name : 1,3,2,4,5
sku_attr_value:
id,......
1,.....
2,.....
3,.....
4,.....
5,.....
*/
select b.* from (select brand_name from shop_brand ) a left JOIN sku_attr_value b on FIND_IN_SET(b.id,a.brand_name)