数组能否按照指定的顺序排序

[zhuhao]

$arr=array(
array(AB,5,CV,DS),
array(AB,4,CV,DS),
array(AB,3,CV,DS),
array(AB,2,CV,DS),
array(AB,1,CV,DS),
array(AB,4,CV,DS),
)

$paixu=array(3,2,1,5,4)

请问arr数组第二列，能不能按照paixu数组里面的顺序排序？

如果mysql查询能按指定的排序最好了！

[xuzuning]

$arr=array(
  array('AB',5,'CV','DS'),
  array('AB',4,'CV','DS'),
  array('AB',3,'CV','DS'),
  array('AB',2,'CV','DS'),
  array('AB',1,'CV','DS'),
  array('AB',4,'CV','DS'),
);

$paixu=array(3,2,1,5,4);
foreach($arr as $v) $r[] = array_search($v[1], $paixu);
array_multisort($r, $arr);
print_r($arr);

Array
(
    [0] => Array
        (
            [0] => AB
            [1] => 3
            [2] => CV
            [3] => DS
        )

    [1] => Array
        (
            [0] => AB
            [1] => 2
            [2] => CV
            [3] => DS
        )

    [2] => Array
        (
            [0] => AB
            [1] => 1
            [2] => CV
            [3] => DS
        )

    [3] => Array
        (
            [0] => AB
            [1] => 5
            [2] => CV
            [3] => DS
        )

    [4] => Array
        (
            [0] => AB
            [1] => 4
            [2] => CV
            [3] => DS
        )

    [5] => Array
        (
            [0] => AB
            [1] => 4
            [2] => CV
            [3] => DS
        )

)

Mysql 中可以这样
select * from tbl_name order by find_in_set(字段, '3,2,1,5,4')