SQL order by fixed values

This is how you can order a select result by fixed values

<?php
SELECT * FROM `logs` ORDER BY  status=3 DESC , status=1 DESC, status=4 DESC
?>
Knowledge keywords: 
MySQL
SQL