title: MySQL Order by Two Columns
body: <p>I have a Table Like Below</p>
  
  <pre>
  
      CREATE TABLE Products(Product_id INT, ProductName VARCHAR(255), 
                            Featured enum('Yes', 'No'), Priority enum('p1', 'p2', 'p3'))
  
  
      INSERT INTO Products(ProductName, Featured, Priority) 
                    VALUES('Product A', 'Yes', 'p1'),
                          ('Product B', 'No',  'p2'),
                          ('Product C', 'Yes', 'p1'),
                          ('Product D', 'No',  'p1'),
                          ('Product E', 'Yes', 'p3'),
                          ('Product F', 'No',  'p2'),
                          ('Product G', 'Yes', 'p1'),
                          ('Product H', 'Yes', 'p2'),
                          ('Product I', 'No',  'p2'),
                          ('Product J', 'Yes', 'p3'),
                          ('Product K', 'Yes', 'p1'),
                          ('Product L', 'No',  'p3');
  
  
  </pre>
  
  <p>I Need to get the Featured products followed by product with priority p1, p2 and p3 </p>
  
  <pre>
  
  Op:
     ProdName | Featured  | Priority
  
      Product A   Yes         p1
      Product C   Yes         p1
      Product G   Yes         p1
      Product K   Yes         p1
      Product H   Yes         p2
      Product E   Yes         p3
      Product J   Yes         p3
      Product D   No          p1
      Product B   No          p2
      Product F   No          p2
      Product I   No          p2
      Product L   No          p3
  
  </pre>
  
  <p>I Wrote a query below which ain't working..</p>
  
  <pre>                                           
    SELECT * 
      FROM Products
     ORDER BY Featured IN ('Yes') desc,
              Priority IN ('p1', 'p2', 'p3') desc
  </pre>
  
  <p>Could u plz spot mistake in that</p>