Comparison using mysql

Can i use the "LIKE" operator on a date in mysql?
I want to compare the information by the different months
Thanks Wesley

Sure, this query selects all orders placed in the month of April,
regardless of the year...

SELECT date FROM orders WHERE date LIKE '%-04-%';

thanks:)

strawberry wrote:
> Sure, this query selects all orders placed in the month of April,
> regardless of the year...
>
> SELECT date FROM orders WHERE date LIKE '%-04-%';

You can, but you can also do:

SELECT date FROM orders WHERE MONTH(date) = 4;

that works brilliantly, thanks
Wes

Yes - but that wasn't the question ;-)

strawberry wrote:
> Yes - but that wasn't the question ;-)

True, that was why I was careful to say "You can, but you can also..." :->

Thanks strawberry and Paul
You guys are both brilliant;)
Wes