遇到一个让人哭笑不得的问题,虽小可是让人琢磨不透!!!
我数据表有一字段time 类型是datetime
里面有数据 2006-01-12 12:12:13
2006-01-14 10:12:22
2006-01-16 09:10:50
我用这条语句select time from biao where time like '2006-01-14%';
有2006-01-14 10:12:22这条数据
但是我用select time from biao where time like '2006-01%';
2006-01-14 10:12:22这条数据丢失
然后我换个方式
select time from biao where time>'2006-01-01 00:00:00' and time<='2006-01-16 23:59:59';
还是丢失,好奇怪啊!1