Aaron-
to reorder results of a column specify
FIELD(ColumnName,1stPosition,2ndPosition) e.g.
mysqluse information_schema;
mysql select ordinal_position,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
from COLUMNS WHERE ORDINAL_POSITION=23 OR ORDINAL_POSITION=18 ORDER BY
On Fri, Jun 5, 2009 at 9:09 AM, Aaron Fischerafisc...@smith.edu wrote:
So I build the query in the order that I want it displayed. That is display
221593, then 221591, then CC3762, etc. However, when the query is executed
it looks like it automatically sorts the codes in ascending order, so I