SQL 语句忽略了 where 参数_数据库问题-跟版网

本文介绍了SQL 语句忽略了 where 参数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！

问题描述

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 参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！

本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！

SQL 语句忽略了 where 参数

问题描述

推荐答案

相关文档推荐