[web] MySql Order-By | GameDev.net

Original Post

Jul 30, 2006 at 2:02 PM

Is there a way to order by column name in mysql? For example, if I have a table with Columns C, A, B, can I make a statment in the query such that the columns will be arranged A, B, C in use with mysql_field_name()? I can technically get all the column names, dump them into an array, then use sort(), but I'd like to avoid that if possible.

evolutional

Jul 30, 2006 at 2:07 PM

select A, B, C from Table order by C

markr

Jul 30, 2006 at 3:13 PM

ORDER BY sorts the rows not the columns in the results.

The columns come out in the order you specify them in the SELECT clause.

Mark

Topic Locked