On 07/10/2005, Erfan Shirazi wrote:
> It works fine, no errors and it seems to get correct data but the
> mysql manual and some other books doesn't mention anything about
> BETWEEN being used like this and therefor I'm not completely sure,
> anybody with any experience with my example?
I regularly use
WHERE CURRENT_DATE() BETWEEN startdate AND enddate
without any problems. In fact the above is equivalent to
WHERE startdate <= CURRENT_DATE() AND CURRENT_DATE() <= enddate
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
