rocknbil - 4:19 pm on Oct 14, 2011 (gmt 0)
Huh? You can use double quotes, if it doesn't conflict with content(? Just tested that). Single quotes are a decent habit to form though, because one approach to coding (in Perl or PHP) is encapsulate select statements in double quotes to allow interpolation of the variables.
$query = "select * from table where the_date='$my_date'";
More correction examples . . .
AND created_at >= date_add('2011-11-01', INTERVAL 2 DAY)
AND created_at >= date_sub('2011-11-01', INTERVAL 2 DAY)
or for an exact match on the day, you don't use the functions.
AND created_at >= '2011-11-01'
AND created_at <= '2011-11-01'
AND created_at = '2011-11-01'
AND created_at <> '2011-11-01'