主页 / 问题 / 1609661
Accepted
Дмитрий
Asked:2025-03-31 21:09:21 +0000 UTC2025-03-31 21:09:21 +0000 UTC

如何合并两个 mysql 查询

  • 772

$id = ...;

$sql = "SELECT * FROM datbase WHERE id < $id ORDER BY id DESC, id DESC LIMIT 5";

和

$sql = "SELECT * FROM datbase WHERE id > $id ORDER BY id ASC, id DESC LIMIT 5";

如何合并为一个请求

php

1 个回答

  1. Best Answer

    举个例子，你可以使用UNION ALL

    $sql = "(SELECT * FROM datbase WHERE id < $id ORDER BY id DESC LIMIT 5)
        UNION ALL
        (SELECT * FROM datbase WHERE id > $id ORDER BY id ASC LIMIT 5)
        ORDER BY id DESC";

    查询将显示所需记录“之前”的 5 条记录和“之后”的 5 条记录id。

    • 0

相关问题