I have a shipment table in the following format:

How I can sort the above table with all the Germany to France appear first, then Landon to France followed by Landon to Germany, then the remaining shipments.

Thanks for the help!

CodePudding user response：

Here's the idea of using a CASE statement inside the ORDER BY clause, as already suggested in the comments:

SELECT 
    * 
FROM 
    Shipments
ORDER BY 
    CASE WHEN `Source` = 'Germany' AND `Destination` = 'France' THEN 1
         WHEN `Source` = 'Landon' AND `Destination` = 'France'  THEN 2
         WHEN `Source` = 'Landon' AND `Destination` = 'Germany' THEN 3
         ELSE 4
    END

Here's a fiddle too: https://www.db-fiddle.com/f/58b3pWrUAeobtNd7yyUwwq/0.