mySQL ORDER BY TODAY AND THEN NORMAL SORTING

Question

How can I filter the dates that it would sort first by today then normal?

I have a column with data type datetime, I wanted my results to be sorted showing today's date first and continue normal sorting.

possible duplicate of [Sorting by date & time in descending order?](http://stackoverflow.com/questions/9511882/sorting-by-date-time-in-descending-order) — , Apr 28 '14 at 23:13
I mean descending order.. so the results would first show this day's values and then from the future to past results — Jay-ar Buño, Apr 28 '14 at 23:18

Eugen Rieck · Accepted Answer · 2014-04-28T23:23:50.413

0

What about

SELECT
  ...
FROM 
  ...
ORDER BY IF(DATE(datefield=CURRENT_DATE()),0,1), datefield DESC

Edit

Added the DESC to the ORDER BY after the 3rd comment to the OQ

edited Apr 28 '14 at 23:23

answered Apr 28 '14 at 23:14

Eugen Rieck

@Strawberry ... which is perfectly productive, but much less instructive. – Eugen Rieck Apr 28 '14 at 23:16
will it still apply if I put datefield in descending order? – Jay-ar Buño Apr 28 '14 at 23:17
@Jay-arBuño Did u try? – Strawberry Apr 28 '14 at 23:18
@Strawberry it sorted by today first, but future results are not shown – Jay-ar Buño Apr 28 '14 at 23:22

1 Answers1