problem with query and date comparison

[peppino]

i want to select any event in the future. my query is:

SELECT * FROM events WHERE eventStartDate >= 2005-12-01 ORDER BY eventStartDate ASC

in my database i have an event with eventStartDate = 2004-12-01 but the query still grabs this entry thinking that it is a future date. i have no idea why! can anyone help?

[Weedpacket]

= means "greater than or equal to"
means "greater than"

eventStartDate > 2005-12-01

[toxic_brain]

use quotes

WHERE eventStartDate >= '2005-12-01'

otherwise mysql 'll takes its maths calculator nd calculate what the f** number is
2005-12-01 = 1992

[toxic_brain]

use quotes

WHERE eventStartDate >= '2005-12-01'

otherwise mysql 'll takes its maths calculator nd calculate what the f** number is
2005-12-01 = 1992