I need to search record as per status id in some sequence
<p>My sql fiddle : <a href="http://sqlfiddle.com/#!9/012138/1" rel="nofollow">http://sqlfiddle.com/#!9/012138/1</a></p>

<p>I have following table :</p>

<blockquote>
  <p>products (TABLE)</p>

<pre><code>id INT(10)
productname VARCHAR(50)
statusid INT(10)
</code></pre>
</blockquote>

<p>Suppose we have following records:</p>

<pre><code>id  productname     statusid
5   P1000              2
6   P2000              1
7   P3000              3
</code></pre>

<p>Now you can see that status id is 1,2,3.  I want to get record as per status id, but status id which we store is in different way so i can not write query to search as per order by statusid directly. Because i need to fetch record as per following status id order</p>

<p>first statusid 3, then status id 1 and then status id 2. How is it possible to write query ?</p>