where date like '2001-07%' ... would find all 2001-07-??.
[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.
>
> Any suggestions would be appreciated.
>
> Thank you for your time,
> Scott Pollak
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
