On Fri, Jun 5, 2009 at 9:09 AM, Aaron Fischer 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 get
> 221591, t
Aaron-
to reorder results of a column specify
FIELD(ColumnName,1stPosition,2ndPosition) e.g.
mysql>use 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
FIELD(ORDINAL_POSI
