php - 使用搜索关键字获取两个表

Question

我有两个表“电影”和“系列”，我想使用关键字同时提取这两个表

所以我尝试这样做，但出现 SQL 错误

$query = $_GET['keyword'];
$query = htmlspecialchars($query);
$stmt = "SELECT series.title, series.pic FROM series UNION SELECT mov_title, mov_pic FROM movies WHERE mov_title LIKE '%$query%' OR title LIKE '%$query%' ";
$result = $pdo->query($stmt);

Answer 1

将您的 UNION 包装在派生表中:

select * from
(
    SELECT series.title as mov_title, series.pic FROM series
    UNION
    SELECT mov_title, mov_pic FROM movies
) dt
WHERE mov_title LIKE '%$query%'

顺便说一句，也许您应该考虑使用UNION ALL？