mysql - 将两个 mysql 查询与两个不同的 order by 语句组合起来

Question

我想合并这两个查询。

   SELECT * FROM table1 WHERE status='pending' and adr='' order by id desc limit 0,1;

   SELECT * FROM table1 where status='pending' and adr='new' ORDER BY RAND() LIMIT 1

Answer 1

您可以使用 UNION ALL 集合运算符来连接两个查询的结果

( SELECT * FROM table1 WHERE status='pending' AND adr='' ORDER BY id DESC LIMIT 1 )
UNION ALL
( SELECT * FROM table1 WHERE status='pending' AND adr='new' ORDER BY RAND() LIMIT 1 )

引用:UNION ALL https://dev.mysql.com/doc/refman/5.5/en/union.html