在mysql中用if…else语句判断当天是否为星期天？

SELECT IF(days = 1,‘是’,‘不是’) as '星期天' FROM (SELECT DAYOFWEEK(date) AS days FROM ceshitable) tmp

这里顺便说一下DAYOFWEEK的用法：DAYOFWEEK(date) (NOTE: 也可小写 dayofweek)返回date (1 = 周日, 2 = 周一, ..., 7 = 周六)对应的工作日索引。mysql>SELECT DAYOFWEEK('1998-02-03')->3

---