56,675
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM 表名 FROM WHERE attr_id IN(151,153) AND attr_value IN('4L','SM')
SELECT * FROM 表名 t
WHERE attr_id =153 and attr_value='4L'
and exists (select 1 from 表名 where attr_id =151 and attr_value='SM' and goods_id =t.goods_id )
SELECT * FROM table WHERE attr_value='4L' OR attr_value='SM'