rocknbil - 4:34 pm on Jan 5, 2012 (gmt 0)
This is probably in error by likely the right direction.
// Cleanse and store date in YYYY-MM-DD format "$date"
select * from table where datefield >= date_sub('$date', interval 2 day) and datefield <= date_add('$date', interval 2 day) order by datefield = '$date' desc, datefield desc;
The order by may need some work, but the idea is to use an expression in the first half of the clasue