FUDforum: comp.lang.php » sql order but move some rows bottom

Home » Imported messages » comp.lang.php » sql order but move some rows bottom

Show: Today's Messages :: Polls :: Message Navigator

Re: sql order but move some rows bottom [message #182407 is a reply to message #182406]

Sat, 03 August 2013 16:31

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

On 03-08-2013 18:10, nawfer wrote:
> Il Sat, 03 Aug 2013 12:53:00 +0200, Luuk ha scritto:
>
>> 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
>>>

>> ORDER BY (column2 = 100) ASC, column1 ASC, column2 ASC
>> ?
>
> but if want also to verified the 3 colum (send bottom also the y) ?

ORDER BY (column2 = 100 or column3='Y') ASC, column1 ASC, column2 ASC

Report message to a moderator

[Message index]

		sql order but move some rows bottom By: nawfer on Sat, 03 August 2013 10:44
		Re: sql order but move some rows bottom By: Luuk on Sat, 03 August 2013 10:53
		Re: sql order but move some rows bottom By: nawfer on Sat, 03 August 2013 16:10
		Re: sql order but move some rows bottom By: Luuk on Sat, 03 August 2013 16:31
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 11:50
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 13:13
		Re: sql order but move some rows bottom By: anver on Sun, 04 August 2013 14:42
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 14:56
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 17:36
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 17:52
		Re: sql order but move some rows bottom By: nawfer on Mon, 05 August 2013 12:50
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 15:49
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 17:37
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 17:53
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 18:20
		Re: sql order but move some rows bottom By: nawfer on Mon, 05 August 2013 12:57

Previous Topic:	fetch items from a row
Next Topic:	Validate Radio Buttons?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 10:26:53 GMT 2024

Total time taken to generate the page: 0.04045 seconds