msyql多个or,and,

大家好，又见面了，我是全栈君。

where (`to`= 2 and `from`= 8) or (`to`= 8 and `from`= 2) and from_unixtime(a.time,’%Y-%m-%d’) =’2017-05-31′ order by a.time desc

select a.*,from_unixtime(a.time,’%Y-%m-%d’) as t1 from oss_msg as a where ((`to`= 8 and `from`= 2 ) or (`to`= 2 and `from`= 8 )) and from_unixtime(a.time,’%Y-%m-%d’) =’2017-05-31′ order by a.time desc

select a.*,from_unixtime(a.time,’%Y-%m-%d’) as t1 from oss_msg as a where ((`to`= 8 and `from`= 2) or (`to`= 2 and `from`= 8)) and from_unixtime(a.time,’%Y-%m-%d’) =’2017-05-31′ order by a.time desc

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/108454.html原文链接：https://javaforall.cn