SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
17. 09. 2009. | #1 |
majstor
Wrote a book
|
Order by IN()
Kôd:
select avatar, user_id from jos_comprofiler where user_id in (71,73,66,70,64,69) ili postoji neki drugi nacin?? hvala |
17. 09. 2009. | #2 |
novi klan
Professional
Datum učlanjenja: 03.02.2007
Poruke: 326
Hvala: 43
427 "Hvala" u 50 poruka
|
Kôd:
select avatar, user_id from jos_comprofiler where user_id in (71,73,66,70,64,69) order by field(user_id,71,73,66,70,64,69)
__________________
We professional we dealin' with business |
17. 09. 2009. | #3 |
majstor
Wrote a book
|
|
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Order articles | Ivan | Planiranje i usability | 3 | 20. 06. 2007. 23:54 |
Dell Inspirion 1150, USB ports out of order | dark_mark | Hardware | 1 | 28. 05. 2007. 11:46 |
ORDER BY visited DESC pa nesto tamo | Blood | SQL baze podataka - Sponzor: Baze-Podataka.net | 3 | 12. 03. 2007. 17:51 |
Order array by relevance... | cvele | PHP | 3 | 25. 08. 2005. 17:10 |