例子是按照is_publish分类(0/1)0的时候按照created_at倒序,1的时候按照deadline倒序
SELECT
*
FROM
`test` AS t
ORDER BY
IF (
(`t`.`is_publish` = 0),
0,
`t`.`deadline`
) DESC,
`t`.`created_at` DESC
例子是按照is_publish分类(0/1)0的时候按照created_at倒序,1的时候按照deadline倒序
SELECT
*
FROM
`test` AS t
ORDER BY
IF (
(`t`.`is_publish` = 0),
0,
`t`.`deadline`
) DESC,
`t`.`created_at` DESC