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
