leafy的专栏

取得当天：SELECT curdate();mysql> SELECT curdate();+------------+| curdate()  |+------------+| 2013-07-29 |+------------+ 取得当前日期：mysql> select now();+---------------------+

在文章数据中加入输入法里面的表情，提交到服务器出现这个错误解决方案：修改mysql对应的字段类型为mediumblob，查询的时候 CAST(c.title AS CHAR CHARACTER SET utf8) AS titletitle为内容字段。资料：http://comeonbabye.iteye.com/blog/1467272 

今天select * from 表名 where to_days(时间字段名) = to_days(now());昨天SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) 7天SELECT * FROM 表名 where DATE_SUB(CURDATE(), INTERVAL 7 DAY)