这样为什么取不到一天的帖子？

[web_jsp]

SELECT * FROM luntan_text where (startdate>=2006-04-11) AND (startdate<2006-04-12)

在数据库试了取不出11号的帖子

高手请指点，谢谢

[intereye]

写法不是这样的~~建议先去看看mysql开发手册~~

[zeroleonhart]

SELECT * FROM luntan_text where (startdate>=2006-04-11) AND (startdate<2006-04-12)
应该是
SELECT * FROM luntan_text where (startdate>='2006-04-11') AND (startdate<'2006-04-12')
吧？

[intereye]

startdate BETWEEN 2006-04-11 AND 2006-04-12

[web_php]

SELECT * FROM luntan_text where (startdate>=2006-04-11) AND (startdate<2006-04-12)
应该是
SELECT * FROM luntan_text where (startdate>='2006-04-11') AND (startdate<'2006-04-12')
吧？

-----------------------------------------------------------------------------------------------------------------------------

就是这样写的