title: mysql order rows by a record with two different values
body: <p>i have records that have value equal to 1 or 2 i want to order rows by this record like this</p>
  
  <pre><code>1
  2
  1
  2
  1
  2
  1
  </code></pre>
  
  <p>how can i do this order by only orders by DESC or ASC ?</p>
  
  <p>note :  there is a primary key id, and there is a created date</p>
  
  <pre><code>CREATE TABLE `users` (
      `uid` INT(11) NOT NULL AUTO_INCREMENT,
      `phone_number` VARCHAR(16) NOT NULL,
      `password` VARCHAR(100) NOT NULL,
      `first_name` VARCHAR(100) NOT NULL,
      `last_name` VARCHAR(100) NOT NULL,
      `sex` TINYINT(4) NOT NULL, &lt;&lt; this will have only 1 or 2
      `created_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `account_status` TINYINT(1) NOT NULL, 
      PRIMARY KEY (`uid`)
  );
  </code></pre>