Сортировка результатов/ MySQL

[Mesrop]

unem mi 320 toxani cucak, mysql -i mej Ruseren Windows-1251 -ov havaqac.
ORDER -ov vor talis em dasavori, motavora dasavorum, aysinqn arajin mi 3 tarerov a dasavorum.
isk tvernel dnuma skzbic 10 -@, heto 2 -@, heto 30 ... (PHP -um natcasesort -ova, bayc SQL -um cgidem)

chka ORDER -ic aveli lav dasavorelu hraman??

[[ Xelgen ]]

Hm.. tver parunakogh dashty qo mot inci tipi e?
Dir tvain tip, integer kam en inch aveli shat e sazum qo depqum..
Et probley petq e vor verana.
Isk Anunneri het, chgitem, im mot anglereni het tenc xndir chi eghel, u yst tramabanutian cyrilicn el chpetq e vor tenc xndirner unena..

Che urish metodner chkan, ORDER BY ev GROUP BY (bayc verjiny papuk asac urish ban e anum)

[Mesrop]

anglereni het klni... ay ruseren@...
tveri hamar, chem kara int dnem..
VarChar a.
mej@ text el ka... orinak
"2-ая улица" es kargi...

[[ Xelgen ]]

Originally Posted by Mesrop

tveri hamar, chem kara int dnem..
VarChar a.
mej@ text el ka... orinak
"2-ая улица" es kargi...

Indz tvuma et depqum normal sirun lucum mian MySQLi ujerov chez karogh anel, kam tvyalnerid struktruan pordzi poxes. Chgitem te konkret qo mot inch xndir e.

[_ WOLF _]

It's so simple...

SELECT * FROM `your_table_name` ORDER BY your_field_name+0;

..or use MySQL CAST function!