Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ordering by a specified order

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Does anyone know hoe to order by a specified order rather than ASC, DESC. For ex. non-unique ids(23,67,12,6,98,56,21) I want to return rows that contain these ids in the specified order. I would like to do this at the database level in order to use LIMIT
 
Hi John,
I'm thinking this is not possible as SQL doesn't have the
means to do this(not that I know of). You could extract
records that contain thoses numbers and still use the
LIMIT function. Then order them using PHP,PERL,c/c++ ...

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top