SELECT * FROM mytable WHERE [add_time] BETWEEN STR_TO_DATE('2013-07-26','%Y-%m-%d') AND STR_TO_DATE('2013-07-29','%Y-%m-%d')
SQL查询指定时间[字符串]范围内的数据
最新推荐文章于 2024-05-08 22:12:20 发布
SELECT * FROM mytable WHERE [add_time] BETWEEN STR_TO_DATE('2013-07-26','%Y-%m-%d') AND STR_TO_DATE('2013-07-29','%Y-%m-%d')