View Single Post
  #1 (permalink)  
Old 05-13-2006, 02:04 PM
ben ben is offline
Administrator
 
Join Date: Mar 2007
Posts: 93
ben has disabled reputation
Default ANY dialect question:

How to order rows in a predefined pattern?


The idea is to always have predefined rows at the beginning of a record set.

For example if you have a column:

id
--------
article_1
article_2
article_3

How can I construct a query to return the rows in the order article_2, article_1, article_3?
Reply With Quote

ANSWER(S):