MySQL Forums
Forum List  »  Connector/C (libmysql)

doubt in select query
Posted by: embeddedsys
Date: April 27, 2005 10:41AM

I have a query like this,

select * from Currency where id='526' or id='504' or id='501' or id='503';

when i execute this query i get records(result set) in the following order.
501
503
504
526

Now my question is, i want a query which will fetch me (store) the records in the same order i have asked for. The desired o/p should be,
526
504
501
503

Kindly help me

Options: ReplyQuote


Subject
Views
Written By
Posted
doubt in select query
790
April 27, 2005 10:41AM
590
April 27, 2005 07:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.