On 07/10/2005, Erfan Shirazi wrote:

> I have a question about BETWEEN.
> Could it be used to look up fields which have a date between to date
> fields?
> 
> Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
> 
> tEffectivedate and tExpirationdate are DATE types.

What happened when you tried?

-- 
felix

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to