mysql - 如何在 MySQL 中使用 AND 和 OR

Question

我想在我的网站上创建一个搜索。在搜索表单中，我有用于搜索的类别和输入查询。例如，在类别 im 中选择 jmovies 并在输入查询中为 ashi 键入关键字。

我的代码

SELECT * 
FROM master_post 
WHERE category = 'jmovies' 
    AND master_post_name LIKE '%ashi%' 
    OR altname LIKE '%ashi%'

因此类别 = jmovies 和关键字 = ashi。

例如我有这样的表

category     master_post_name    alt_name
===========  ==================  ===============
JMovies      ashi_include_1      not_include
JMovies      ashi_include_2      not_include
JMovies      ashi_include_3      not_include
JMovies      not_include         ashi_include_1
JMovies      not_include         not_include
Drama        ashi_in_drama       ashi_include_2

如果我用那个代码运行结果是

category     master_post_name    alt_name
===========  ==================  ===============
JMovies      ashi_include_1      not_include
JMovies      ashi_include_2      not_include
JMovies      ashi_include_3      not_include
JMovies      not_include         ashi_include_1
Drama        ashi_in_drama       ashi_include_2

问题是，因为我选择了jmovies，类别drama 不应该出现在我的结果中，即使drama 在 中有ashi>master_post 或 alt_name。

结果一定是这样的

category     master_post_name    alt_name
===========  ==================  ===============
JMovies      ashi_include_1      not_include
JMovies      ashi_include_2      not_include
JMovies      ashi_include_3      not_include
JMovies      not_include         ashi_include_1

即使我选择 jmovies 而不是填写 input keyword 结果也不仅仅显示 jmovies 但它也显示 drama。

注意:alt_name 和 ma​​ster_post_name 具有相同的关键字。

Answer 1

我不确定我是否正确理解你的问题，但你可以尝试以下查询:

SELECT * FROM master_post 
WHERE category = 'jmovies' AND (master_post_name LIKE '%ashi%' OR altname LIKE '%ashi%')

我怀疑这里的“问题”在于 AND 运算符的优先级高于 OR 运算符。