title: Get order of query result according to 'IN' clause in the query  in cake php or mysql
body: <p>In cake php is how we can get order of query result according to 'IN' clause in the query</p>
  
  <pre><code>$array = array(8,6); // order in 'In' clause
  $condition = array('Video.id' =&gt; $array);
  $videos = $this-&gt;Video-&gt;find('all', array('conditions' =&gt; $conditions));
  
  //The query will be like below
  SELECT * FROM `videos` AS `Video` WHERE `Video`.`id` IN (8,6);
  </code></pre>
  
  <p>Currently it will give result as </p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
      (
          [Video] =&gt; Array
          (
              [id] =&gt; 6
          )
  
      )
  
      [1] =&gt; Array
      (
          [Video] =&gt; Array
          (
              [id] =&gt; 8
          )
  
      )
  
  )
  </code></pre>
  
  <p>I need it like </p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
      (
          [Video] =&gt; Array
          (
              [id] =&gt; 8
          )
  
      )
  
      [1] =&gt; Array
      (
          [Video] =&gt; Array
          (
              [id] =&gt; 6
          )
  
      )
  
  )
  </code></pre>
  
  <p>order Desc or asc will not retreive actual result in order. How it can retreved using cake php ?</p>
  
  <p>I am using cake php, whether this can be done in mysql ?</p>