Displays 3,2,1,0,0,0... how to deduce 1,2,3,0,0,0...

    1 answer 1

     SELECT `field1`, `field2`, `your_field` FROM `table` ORDER BY IF(`your_field` = ?, 1, 0), your_field ASC

    Where instead ? value that should be at the end. In your case, this is zero.