Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #10358
| Path | csiph.com!usenet.pasdenom.info!dedibox.gegeweb.org!gegeweb.eu!nntpfeed.proxad.net!proxad.net!feeder2-2.proxad.net!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail |
|---|---|
| Date | Sat, 03 Aug 2013 18:31:13 +0200 |
| From | Luuk <luuk@invalid.lan> |
| User-Agent | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130620 Thunderbird/17.0.7 |
| MIME-Version | 1.0 |
| Newsgroups | comp.lang.php, alt.php |
| Subject | Re: sql order but move some rows bottom |
| References | <1qthmi1tu68bo$.9vs28kns3wda.dlg@40tude.net> <b14vca-jku.ln1@luuk.invalid.lan> <13413lih7j7xy.ntybohdhh9wy.dlg@40tude.net> |
| In-Reply-To | <13413lih7j7xy.ntybohdhh9wy.dlg@40tude.net> |
| Content-Type | text/plain; charset=ISO-8859-1; format=flowed |
| Content-Transfer-Encoding | 7bit |
| Message-ID | <frnvca-j63.ln1@luuk.invalid.lan> (permalink) |
| Lines | 15 |
| NNTP-Posting-Host | 2001:980:9089:1:b900:c8e4:3423:5055 |
| X-Trace | 1375547701 news.xs4all.nl 15954 [2001:980:9089:1:b900:c8e4:3423:5055]:39312 |
| X-Complaints-To | abuse@xs4all.nl |
| Xref | csiph.com comp.lang.php:10358 |
Cross-posted to 2 groups.
Show key headers only | View raw
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
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-03 12:44 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-03 12:53 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-03 18:10 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-03 18:31 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 13:50 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 15:13 +0200
Re: sql order but move some rows bottom anver <NOSPAMM@NO.SPAMMS> - 2013-08-04 16:42 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 16:56 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 19:36 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 19:52 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-05 14:50 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 17:49 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 19:37 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 19:53 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 20:20 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-05 14:57 +0200
csiph-web