mysql version?
http://dev.mysql.com/doc/refman/5.0/en/case-statement.html
order by case when updated is not null then updated else created end desc;
/Kristian
On Tue, Apr 8, 2008 at 1:04 PM, Richard <mysql_list@stripped> wrote:
> Hello,
> I've got a table which containes two date colomns.
> The first one is called `date` and the second `update`
> In the first one I put the ticket creation date, and on update I add or
> change the update value.
> So the update colomn does not contain a value until the first update has
> been done.
> I would like to order the tickets by their last update value. And if this
> value does not exist use the date value.
>
> at the moment I use this :
>
> ORDER BY `date` DESC"
> and I would like to replace it by something like this :
>
> ORDER (IF `update`!= '' BY UPDATE ELSE BY DATE)
>
> I know this code is completly wrong, just to try and show you what I need
> ...
>
> Here is an example of what I want to achieve
>
> num | date | update
> -------------------------------------------
> 1 | 1 |
> 2 | 10 | 60
> 3 | 20 |
> 4 | 30 |
> 5 | 40 | 90
> 6 | 50 |
>
> The required result would be :
>
> num | date | update
> -------------------------------------------
> 5 | 40 | 90
> 2 | 10 | 60
> 6 | 50 |
> 4 | 30 |
> 3 | 20 |
> 1 | 1 |
>
> Thanks in advance :)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
