PHP SQL Condition on ORDER BY

Question

I am trying to display all records with field_featured = 1 to start at the top of my listing ... and all the others to display at RAND()

So...

SELECT * FROM myTable

If (field_featured = 1 then ORDER BY field_featured) OTHERWISE (ORDER BY RAND() )

How can I do this?

Answer 1

Try this:

ORDER BY (field_fieatured=1) DESC, RAND()