I have this query : 
$query = "SELECT \* FROM table1 ONE ORDER BY ....:

the order should be in this way :

1. first the mysql should get the rows with status 2.
2. then get the row with status 1.
3. then get the row with status 3.

\*\*status is a col at table1.