[SQL] How to sort character

[Napster]

i want sort item id and order by name of item A-Z or 0-9

how to query for this ?

query_sql "SELECT `item_id`FROM "+ $@item_db$ +" WHERE  `id`> 0 GROUP BY `item_id` ORDER BY `id` ASC LIMIT 128;

thank you

[Emistry]

ORDER BY `name_english` LIMIT 128;

[Napster]

@Emistry

map server show error unknow 'name_english' field

and field item_id = value number only not string

no have idie convert  item id --> item name ---> sort name

[Emistry]

change the column name to your item table with appropriate colum name.