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的意思


原文地址:https://www.cnblogs.com/liangfc/p/7392755.html