MYSQL查询日期介于

Question

这个查询有什么问题？

select  a.TESTDATE  from testr a,XREFRTGTE b where a.id = b.id and a.TESTDATE between BETWEEN STR_TO_DATE('2011-05-26 12:22:33','YYYY-MM-DD HH:MM:SS') AND STR_TO_DATE('2011-06-02 12:22:33','YYYY-MM-DD HH:MM:SS') limit 200

请帮帮忙

Answer 1

我可以看到查询中使用了两个between：

... between BETWEEN ...

试着扔掉一个。