I am displaying a list of categories in ASC order."OTHERS" is also one of the category. I need to display all categories in ASC ORDER and "OTHERS" in last .

Question

I am displaying a list of categories in ASC order."OTHERS" is also one of the category. I need to display all categories in ASC ORDER and "OTHERS" in last .

This is done by using PHP and MYSQL.

TABLE STRUCTURE

tale name: categories

id categoryname

1  APPLE

2  BANANA

3  Strawberry

4  Other

5  grape

For example: the above is the table structure. From the above table i need to display all the categories in ASC Order and need to display "OTHER" at last. So the output should be exactly like below.

id categoryname

1  APPLE

2  BANANA

3  grape

4  Strawberry 

5  Other

Thanks n advance...

Answer 1

SELECT * FROM categories ORDER BY Column1 ASC, Column2 ASC, Column3 DESC

Answer 2

You could try something like

SELECT  *
FROM    Categories
ORDER BY    CASE 
                WHEN Categorie = 'OTHERS' THEN 2 
                ELSE 1 
            END, 
            Categorie

Answer 3

SELECT *
FROM categories
ORDER BY categories LIKE 'others' ASC, categories ASC