select id,title,content from myarticle where id IN(219,220,222,225) and content like '明明' or title like '明明';
用 where id IN(219,220,222,225),给我返回别的 267的文章怎么让后面的like 根据 IN的结果做模糊?谢谢了
闭关修行中......
雷雷
and的优先级比or高,所以A and B or C实际是(A and B) or C,你要用括号来改变优先级A and (B or C)才行。
A and B or C
(A and B) or C
A and (B or C)
雷雷
and的优先级比or高,所以
A and B or C
实际是(A and B) or C
,你要用括号来改变优先级A and (B or C)
才行。