本文共 345 字,大约阅读时间需要 1 分钟。
关于时间的模糊查询 mysql
1. select * from tableName where fieldName like '2009-12-29%';
2. select * from tableName where ( datediff ( fieldName , '2009-12-29' ) = 0 );
3. select * from orders where tableName between '2009-12-10 24:00:00' and '2009-12-29 23:00:00';
4. select * from tableName where year(fieldName)='2009' And month(fieldName)='12';
参考: ()
转载地址:http://yeici.baihongyu.com/