SQL语句忽略了where参数 [英] SQL statement is ignoring where parameter

问题描述

SELECT * FROM people 
WHERE
university='2' 
AND MATCH (lname,fname) AGAINST ('+massive' IN BOOLEAN MODE) 
OR (fname LIKE '%box%' OR lname LIKE '%box%') 

此查询允许对除university='2'以外的结果进行过滤，因此我将如何对其进行更新，因此它仅严格显示大学= 2时的结果

This query is allowing results to filter through other than those of university='2' how would I update this so it strictly only shows results where university = 2

我将全文搜索与LIKE结合使用的原因是，由于全文搜索具有的最小字母数，并且由于我处于共享主机计划中，因此无法修改设置.结果，我将全文和LIKE结合起来以适应

The reason I have combined fulltext search with LIKE is because of the minimum letter count that full text search has and because I am on a shared hosting plan I am unable to modify the settings. As a result I have combined both full text and LIKE in order to accommodate

推荐答案

修正括号

SELECT * FROM people 
WHERE
    university='2' 
    AND (MATCH (lname,fname) AGAINST ('+massive' IN BOOLEAN MODE) 
         OR fname LIKE '%box%' 
         OR lname LIKE '%box%') 

AND的优先级高于OR，因此university = '2'仅与MATCH组合，而不与fname/lname测试结合.

AND has higher precedence than OR, so university = '2' was only being combined with MATCH, not with the fname/lname tests.

这篇关于SQL语句忽略了where参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！