title: Specific ORDER BY clause in MySQL
body: <p>My MySQL database contains Multiple products stored in 4 categories. All informations are in the same table :</p>
  
  <pre><code>id - name - description - price - category
  </code></pre>
  
  <p>I'am trying to list them in this order. I wonder do this only by MySQL request if possible.</p>
  
  <pre><code>Cat1 : product-name-with-lower-price1
  Cat2 : product-name-with-lower-price1
  Cat3 : product-name-with-lower-price1
  Cat4 : product-name-with-lower-price1
  
  Cat1 : product-name-with-lower-price2
  Cat2 : product-name-with-lower-price2
  Cat3 : product-name-with-lower-price2
  Cat4 : product-name-with-lower-price2
  
  Cat1 : product-name-with-lower-price3
  Cat2 : product-name-with-lower-price3
  Cat3 : product-name-with-lower-price3
  Cat4 : product-name-with-lower-price3
  </code></pre>
  
  <p>etc...</p>
  
  <p>I'm sorry to not give any source code I tested because every thing I tried don't work. I think to use the MySQL Order By clause but I don't know how.</p>
  
  <p>Many thx</p>
  
  <p>EDIT : </p>
  
  <p>Products are listed by lower price. After extract lower price of each Cat, we Order by price ASC. Then extract next lower-price of each cat and order by price ASC and so on...</p>
  
  <p>So it could look like this :</p>
  
  <pre><code>Cars : Aygo 8000$
  Moto : Suzuki 8200$
  Bus : Renault 8700$
  Truck : Peugeot 9000$
  
  Cars : Toyota 9300$
  Bus  :  Renault 9400$
  Truck : DMG 9600$
  Moto : Harley 14000$
  
  
  Bus : Mercedes 12000$
  Moto : BMW : 18000$
  Cars : Mercedes 11000$
  Truck : Renault 10000$
  </code></pre>