mysql - sql 选择如果和排序依据

Question

我有一个这样的查询:

   SELECT priority, likes FROM table ORDER BY priority, likes DESC;

优先级和喜欢是整数民意调查。我想添加“IF”子句

  IF (priority > 1 AND priority < 100)
  {
      ORDER BY priority;
  }
  ELSE
  {
      ORDER BY likes DESC;
  }

不知道怎么问。预先感谢您

Answer 1

尝试以下操作

ORDER BY CASE WHEN priority > 1 AND priority < 100 THEN priority ELSE likes END DESC