php - 我的 MySQL 查询不起作用

Question

我有以下查询，它在剧集指南数据库中搜索用户输入的数据:

$query = "SELECT * 
            FROM epguide 
           WHERE EpisodeTitle LIKE '%$trimmed%' 
              OR Synopsis LIKE '%$trimmed%' 
              OR Notes LIKE '%$trimmed%' 
        ORDER BY o";

这工作正常，但是当我添加 'Series = '$ser' AND' 时它停止了:

$query = "SELECT * 
            FROM epguide 
           WHERE Series = '$ser' 
             AND EpisodeTitle LIKE '%$trimmed%' 
              OR Synopsis LIKE '%$trimmed%' 
              OR Notes LIKE '%$trimmed%' 
        ORDER BY o";

看起来应该可以。我该怎么做才能修复它？

Answer 1

使用:

  SELECT * 
    FROM epguide 
   WHERE Series = '$ser' 
     AND (EpisodeTitle LIKE '%$trimmed%' 
          OR Synopsis LIKE '%$trimmed%' 
          OR Notes LIKE '%$trimmed%')
ORDER BY o

您需要括号来分隔/分组 WHERE 子句中的语句。