Untitled

where OR where mysql - mysql query with two where clauses

$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";

       

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

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