first display featured items, then non-featured (was "Query help")

[barbara1712]

Hello guys,

I am having the table called 'item_details' and suppose it contains 50 items
in my table.Out of 50 suppose 30 items are featured and remaining are not.
Now I want to display all the items in the table.
But it should first display the featured items and then the non-featured items.

How should I query?
Your help will be highly appriciated.

Thanks,

[mwasif]

How do you distinuish between featured and non-featured? If you have some field for then, then simply put
ORDER BY is_featured

[r937]

ORDER BY is_featured DESC

assuming is_featured=1 means it is featured, and is_featured=0 means it isn't

[barbara1712]

Thanks mwasif and r937,
I tried and got the correct results.