>>
>> -Original Message-
>> From: Nathan Sullivan
>> Sent: Thursday, July 02, 2009 1:07 PM
>> To: 'Ravindra Harige'; mysql@lists.mysql.com
>> Subject: RE: Adhoc sorting requirement
>>
>> Ravindra,
>>
>> Maybe something like th
p, interval 2 day))) then 3
> else 4
> end, date_field_3, date_field_2, date_field_1;
>
> -Original Message-
> From: Nathan Sullivan
> Sent: Thursday, July 02, 2009 1:07 PM
> To: 'Ravindra Harige'; mysql@lists.mysql.com
> Subject: RE: Adhoc sorting requirement
&
27;; mysql@lists.mysql.com
Subject: RE: Adhoc sorting requirement
Ravindra,
Maybe something like this?
order by
case
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 1
when (date_field_2 between date(current_timestamp) and
dat
Ravindra,
Maybe something like this?
order by
case
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 1
when (date_field_2 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 2
when (date_field_3
