mySql中In and or

in


 

$sql="SELECT * FROM product_detail WHERE did IN(SELECT proId FROM xm_star) ";
product_detail查询要求是,在xm_star中查询到proId(可以是多个)
where id in (1,2,3)
就是查询id=1 or id=2 or id=3的意思


posted @ 2017-08-19 00:56  追忆枉然  阅读(887)  评论(0编辑  收藏  举报