Hello,
Is there any way to get MySQL to return the results of this query with
the 'fieldname' in the order listed in the in() bit?
select fieldname from tablename where fieldname in
('B4079','B4076','B4069','B4041','A4710','58282','58220','56751','56728'
,'45003','09234','04200','04035','04026');
i.e. I want row 1 to have fieldname=' B4079', row 2 to have
fieldname='B4076', etc.
Or is there any other way to list the results by the order as defined in
a list specified in the query.
Please don't reply saying that I should do this in the application layer
as that isn't an option.
Thanks for any help at all on this...
Cheers,
Andrew
MySQL, Query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
