Is there an abstract way to refer to field names in a result set?

For example:

select ID, Name, Price from Products order by field(1)


where "field(1) would be the abstract way of referring to the specific field to sort 
on.

It's for a function that allows me to display tables and sort by column independent of 
the actual data.

Thanks for any ideas or advice you have.

-Ed


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to