title: MySQL Order from a starting value
body: <p>On a product page I have a dropdown that lists current colour options associated to product page. </p>
  
  <p>In this example, the product page SKU is 250E and it available in:</p>
  
  <pre><code>GREEN
  BLACK
  </code></pre>
  
  <p>If the customer selects GREEN, then I want to run a MySQL command that will change the data to show GREEN values first based in the custom_order value shown below.</p>
  
  <p>The start value should overide the other data items and then it should retain custom_order values. The custom_order field has letters like c1, c2 (they will always be at the bottom)</p>
  
  <pre><code>Colour Table
  ============
  ID      COLOURID        NAME
  -------------------------------------
  2           5           BLACK
  3           6           GREEN
  
  
  Product Table
  =============
  ID      SKU         PICTURE URL             COLOURID            CUSTOM_ORDER        
  -----------------------------------------------------------------
  22      250E        cdn_hash_1.jpg          5                   1
  23      250E        cdn_hash_2.jpg          5                   2
  24      250E        cdn_hash_3.jpg          5                   3
  225     250E        cdn_hash_4.jpg          5                   4
  226     250E        cdn_hash_5.jpg          6                   5
  227     250E        cdn_hash_6.jpg          6                   6
  325     250E        cdn_hash_c1.jpg         -                   c1
  426     250E        cdn_hash_c2.jpg         -                   c2
  527     250E        cdn_hash_c3.jpg         -                   c3
  </code></pre>
  
  <p><strong>SELECT * FROM products WHERE ORDER BY custom_order DESC</strong></p>
  
  <p>Now, I want to do the following:</p>
  
  <p><strong>SELECT * FROM products WHERE ORDER BY custom_order AND START VALUE = '6'</strong></p>
  
  <p>Therefore, no matter what, the c1, c2 remain intact, result would be:</p>
  
  <pre><code>22      250E        cdn_hash_5.jpg          6                   5
  23      250E        cdn_hash_6.jpg          6                   6
  24      250E        cdn_hash_1.jpg          5                   1
  225     250E        cdn_hash_2.jpg          5                   2
  226     250E        cdn_hash_3.jpg          5                   3
  227     250E        cdn_hash_4.jpg          5                   4
  325     250E        cdn_hash_c1.jpg         -                   c1
  426     250E        cdn_hash_c2.jpg         -                   c2
  527     250E        cdn_hash_c3.jpg         -                   c3
  </code></pre>