select id from mydata order by name.
If that puts the #125 first etc. simply created a field called 'order_field' or whatever and put numeric values in them. The SELECT id, name FROM mytable ORDER by order_field.
dan orlic wrote:
Ok, I have a client that has a specific request. the ordering of data. For example current the order by returns this:
id | Name ---------- 1 | #124 2 | #125 3 | #155 4 | apples 5 | bacon
but he would rather see the data as :
id | Name ---------- 1 | apples 2 | bacon 3 | #124 4 | #125 5 | #155
how would I contruct that query? many thanks...
dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
