andre Posted October 10, 2003 Report Share Posted October 10, 2003 SELECT * FROM `table` order by name asc tad pirms burta A buuus arii tie ieraksi kuros ir tukshums, kaa to var apiet, taa lai paraadaaas pirmie ieraksti ar burtu A, B, C ...Z un tad ar ciipariem un tushumem, pie tam neizmantojot 2 qverijus, tipa sakumaa select where name<>'' order by name asc un peec tam select where name='' order by name asc taa neder :( Link to comment Share on other sites More sharing options...
Aleksejs Posted October 10, 2003 Report Share Posted October 10, 2003 Pats neesmu to dariijis, bet varbuut vari izmeegjinaat sho: MySQL::Database Administration::The Character Definition Arrays Link to comment Share on other sites More sharing options...
Venom Posted October 11, 2003 Report Share Posted October 11, 2003 Izmanto vienu "sarežģītāku" kvēriju: (SELECT * FROM table WHERE `name`<>'' ORDER BY name ASC) UNION (SELECT * FROM table WHERE `name`='' ORDER BY name ASC) Varētu noderēt arī SELECT BINARY Link to comment Share on other sites More sharing options...
andre Posted October 12, 2003 Author Report Share Posted October 12, 2003 ar UNION nesanaaca :( Link to comment Share on other sites More sharing options...
Venom Posted October 13, 2003 Report Share Posted October 13, 2003 Datubaazes tips, versija? Kluudas pazinjojums? UNION domaats MySQLam ap 4 versiju. Sk. Manuaali. Link to comment Share on other sites More sharing options...
Recommended Posts