/**
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)
网友评论