| Re: sql order but move some rows bottom [message #182405 is a reply to message #182404] |
Sat, 03 August 2013 10:53   |
Luuk
Messages: 329
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 03-08-2013 12:44, nawfer wrote:
> I would like to order a list; sorted by column 1,
> but when the elements have the value 100,
> move them at the end of the list
>
> A)
> if I have 2 columns
> a 2
> b 1
> c 100
> d 1
> a 100
> b 1
> c 2
> d 1
>
> B)
> to sort by column 1
> a 2
> a 100
> b 1
> b 1
> c 2
> c 100
> d 1
> d 1
>
> C)
> but make sure that when I 100 the row is moved under
> a 2
> b 1
> b 1
> c 2
> d 1
> d 1
> a 100
> c 100
>
> how can solve both with sql and with php? I was interested in both
> solutions although I prefer to understand first how can do with sql;
>
> the sql after fill the php array;
>
> if I use ORDER BY column1 ASC, (column2 = 100) ASC
> in reality does how in B)
>
ORDER BY (column2 = 100) ASC, column1 ASC, column2 ASC
?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]