MySQL if 函数实现类似Oracle decode函数功能
SQL
SELECT if(timestampdiff(hour, sa.add_time, now()) < 1000,
if(timestampdiff(hour, sa.add_time, now()) < 300,
if(timestampdiff(hour, sa.add_time, now()) < 128, 3 , 2 ) , 1 ) , 0 ) diftime
f...
原创
2018-10-08 16:39:17 ·
1674 阅读 ·
0 评论