SQL 语句忽略 where 参数

本教程将介绍SQL 语句忽略 where 参数的处理方法,这篇教程是从别的地方看到的,然后加了一些国外程序员的疑问与解答,希望能对你有所帮助,好了,下面开始学习吧。

SQL 语句忽略 where 参数 教程 第1张

问题描述

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

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

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

解决方案

Fix your parentheses

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

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

好了关于SQL 语句忽略 where 参数的教程就到这里就结束了,希望趣模板源码网找到的这篇技术文章能帮助到大家,更多技术教程可以在站内搜索。