SELECT * FROM `qilong_mall_order` where DATEDIFF(NOW(),from_unixtime(addtime,‘%Y-%m-%d‘)) < 3 limit 10
查询订单超过三天的数据
原文：http://www.cnblogs.com/mashil/p/6418513.html
