Order database results with specific field values

Order database results with specific field values.sql

-- Specific order clause
-- In PostgreSQL can be used CASE ... WHEN in order clause:

ORDER BY
   CASE field_to_order
      WHEN 'value1' THEN 1
      WHEN 'value2' THEN 2
      WHEN 'value3' THEN 3
      ELSE 4 
   END, 
   other_field_to_order
   

-- In MySQL can be used also FIELD() function