RE: Ordering an IN query

2009-06-05 Thread Martin Gainty
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

Re: Ordering an IN query

2009-06-05 Thread Perrin Harkins
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