On 13-Jul-01 [EMAIL PROTECTED] wrote:
> Hello,
> 
> I am still a beginner, but I am trying to learn MySQL.  If you have a 
> date field, and you are using the date field in your where clause, I 
> understand how to use :
> WHERE date="yyyy-mm-dd";      I am trying to find out if there is anyway 
> to use the wildcard character %  in dates like you can in text fields.  
> I wanted to be able to say,
> WHERE date="yyyy-mm-%%" or something to that effect.  I know that if I 
> do:
> WHERE YEAR(date)="yyyy" and Month(date)="mm"
> which will do the same thing, but I was curious if you could do it the 
> other way.
> 

Did you try it ?
   ... or where you expecting everyone else to do it for you ?

-- 
Don Read                                       [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to