Page 1 of 1

Hi,i need some help in ORDER BY

Posted: Sun Jun 17, 2012 3:29 am
by mekha
i have 2 columns:
1)pages_id (the id's of pages 1,2,3...)
2)pages_paid(yes,no)
...
i need in my query to SELECT...FROM...WHERE...ORDERY BY:first where pages_paid='yes' and then by id...i mean: the pages_paid be first...and then to order the other products by id :S...please

Re: Hi,i need some help in ORDER BY

Posted: Sun Jun 17, 2012 4:38 am
by social_experiment
Have a look at example 4 on the page below
http://www.techonthenet.com/sql/order_by.php