Comparison using mysql

[wesley@ispace.co.za]

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

[strawberry]

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

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

[wesley@ispace.co.za]

thanks:)

[Paul Lautman]

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;

[wesley@ispace.co.za]

that works brilliantly, thanks
Wes

[strawberry]

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

[Paul Lautman]

strawberry wrote:

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

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

[wesley@ispace.co.za]

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