ORDER BY using a list of elements

buzy · #1 (**permalink**) 02-19-04, 05:29

Hi,
I have to order a select in a special way, just using the name of the product. Can I use a list of the names of the products to do the ordering?
like "product 1", product 3", "product 5", "product 2", "product 4"...
The list of the products it's not so large and I could write them in a simple sentence. I'm working with Microsoft SQL Server 2000.

Thanks & regards

andrewst · #2 (**permalink**) 02-19-04, 05:52

How about a CASE statement?

PHP Code:


			
ORDER BY

  CASE WHEN name='product 1' THEN 1

       WHEN name='product 3' THEN 2

       ...

       END;

Or, perhaps better, add a new column like PRODUCT_PRIORITY to the table and order by that.

Internet Services

Web Development

Digital Marketing

Consumer Tech