mysql 查询结果 排序的问题

Question

用like查询 如查询aaa 返回的结果为：
1.aaabb
2.aaac
3.aaa
4.aaadd
...请问有什么办法可以将aaa放到第一条显示 其他的顺序随意附上我代码中的sql语句-----------------------------------------$keyword = $searchProduct;
if($keyword != '')
{
    $whereSql .= " AND ( CONCAT(shop.mouserid,' ',shop.suppnm) LIKE '%$keyword%') ";
}
if($typeid != '')
{
    $whereSql .= " AND arc.typeid = '$typeid'  ";
}
if($flag != '')
{
    $whereSql .= " AND FIND_IN_SET('$flag', arc.flag) ";
}if($ecat != '')
{
    $whereSql .= " AND shop.protypeid = '$ecat'  ";
}$orderby = empty($orderby) ? 'id' : preg_replace("#[^a-z0-9]#", "", $orderby);
$orderbyField = 'arc.'.$orderby;$query = "SELECT arc.*,
shop.mouserid,shop.suppnm,shop.suppid,shop.mouserstocknb,shop.mouserproimg,shop.mouserrohs,shop.mouserdesc,
shop.pricelevel1,shop.pricelevel2,shop.pricelevel3,shop.pricelevel4,shop.pricelevel5,
shop.pricelevel6,shop.pricelevel7,shop.pricelevel8,shop.pricelevel9,
shop.pricelevel10,shop.pricevalue1,shop.pricevalue2,shop.pricevalue3,shop.pricevalue4,
shop.pricevalue5,shop.pricevalue6,shop.pricevalue7,shop.pricevalue8,shop.pricevalue9,shop.pricevalue10,shop.protypeid
FROM `#@__archives` arc 
inner join `#@__addonshop` shop on arc.id = shop.aid
$whereSql
ORDER BY $orderbyField DESC";mysql selectlike

Answer 1

mysql> select * from tbb order by case when colname='aaa' then 1 else 2 end;
+------+---------+
| id   | colname |
+------+---------+
|    3 | aaa     |
|    1 | aaabb   |
|    2 | aaac    |
|    4 | aaadd   |
+------+---------+
4 rows in set (0.00 sec)