RE: wildcard date searching

2001-07-13 Thread Chris Bolt
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=-mm-dd; I am trying to find out if there is anyway to use the wildcard character % in dates

Re: wildcard date searching

2001-07-13 Thread Dibo Chen
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=-mm-dd; I am

RE: wildcard date searching

2001-07-13 Thread Don Read
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=-mm-dd; I am trying to find out if there is anyway to use