php - where OR where mysql - 带有两个 where 子句的 mysql 查询

Question

我有一个 SQL 语句:

$sql =" SELECT DISTINCT
            scr.*  
        FROM scr 
            LEFT JOIN `users` ON `users`.user_id=scr.user_id

        WHERE $email_filter LOWER(scr.genre) LIKE '%$search_word_fix%' **HERE** $psez protage $wwc $prevoption $locatio  $rats $rat1 $rat2 $rat3 $rat4          
        GROUP by scr.sp_name  
        ORDER BY scr.grade DESC";

当我在“HERE”中添加 lower(scr.classification) like '%$search_word_fix%' 时它没有显示正确的结果。我在想类似的东西(这里是 scr.genre = "searchkeyword"和其他过滤器)或者(这里是 scr.classification = "searchkeyword"和其他过滤器)

Answer 1

只指定 Where 一次。附加子句仅用“或”和“和”指定

使用parans对操作顺序进行分组

where (scr.genre = "searchkeyword" and other filters here) 
OR (scr.classification ="searchkeyword" and other filters here)