mysql能不能做判断_下面的判断，能在mysql里面做判断吗。？

if($order_status==0){$status='新订单';}elseif(($order_status==1&&$pay_status==0)||($order_status==5&&$shipping_status==5&&$pay_status==0)){$status='处理中';}elseif(($orde...

if ($order_status == 0)

{

$status = '新订单';

}

elseif (($order_status == 1 && $pay_status == 0) || ($order_status == 5 && $shipping_status == 5 && $pay_status == 0))

{

$status = '处理中';

}

elseif (($order_status == 1 || $order_status == 5 || $order_status == 6) && ($order_status == 1 || $order_status == 2) && ($shipping_status == 0 || $shipping_status == 3))

{

$status = '已付款';

}

elseif ($order_status == 5 && $shipping_status == 5 && $pay_status == 2)

{

$status = '发货中';

}

elseif (($order_status == 1 || $order_status == 5) && $shipping_status == 1 && ($pay_status == 0 || $pay_status == 2))

{

$status = '已发货';

}

elseif (($order_status == 1 || $order_status == 5) && $shipping_status == 2)

{

$status = '已完成';

}

elseif ($order_status == 4)

{

$status = '退货中';

}

elseif ($order_status == 2 || $order_status == 3)

{

$status = '无效订单';

}

展开