Q:

Best way to perform mySQL queries and arrange the results

I need to be able to display the results of the below query in a specific order. For example: showing featured listings before the rest of the results. 
WHERE IS `featured-listing` && WHERE IS NOT `featured-listing`

Could probably run 2 queries and a union right, bu is that the most effective solution? I know this can be done with one query I just cant remember how it/s done. Any and all help is appreciated.
SELECT `Assigned-Regions`,`Description`,`Category`,`Start-Date` FROM `adds` WHERE `Status` = "Active" ORDER BY `Start-Date` DESC

A:

I would use a case statement for ORDER BY.
So something like 
    SELECT ... ORDER BY (CASE WHEN featured-listing THEN 1 ELSE 2) ASC, some-other-field ASC

