id小于5的倒着排序,id大于5的正着排序
SELECT id, nickname, avator
FROM user_info
WHERE id < 10
ORDER BY IF(id < 5, -id, id)
id小于5的倒着排序,id大于5的正着排序
SELECT id, nickname, avator
FROM user_info
WHERE id < 10
ORDER BY IF(id < 5, -id, id)
微信支付
支付宝