On Mon, 12 Jan 2004, Ed Lazor wrote: > Is there an abstract way to refer to field names in a result set? > 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.
ORDER BY # Where # is the number of the column counting from left to right starting at 1. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
