关于时间的模糊查询 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://www.diybl.com/course/7_databases/database_other/20090426/165388.html)