SQL statement is ignoring where parameter

by

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.

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to declare a variable in MySQL?
  6. How to populate a table with a range of dates?
  7. Error Code: 2013. Lost connection to MySQL server during query
  8. SQL Performance UNION vs OR
  9. How do I select an entire row which has the largest ID in the table?
  10. Adding a leading zero to some values in column in MySQL
  11. Using SQL to determine word count stats of a text field
  12. Update one MySQL table with values from another
  13. MySQL/MariaDB – order by inside subquery
  14. How to transpose mysql table rows into columns
  15. View’s SELECT contains a subquery in the FROM clause
  16. Can MySQL replace multiple characters?
  17. MySQL incorrect key file for tmp table when making multiple joins
  18. Using ORDER BY and GROUP BY together
  19. Does the order of conditions in a WHERE clause affect MySQL performance?
  20. Difference between these two joining table approaches?
  21. Select a column with a keyword name
  22. MySQL Stored Procedures not working with SELECT (basic question)
  23. MySQL query, MAX() + GROUP BY
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. MySQL export into outfile : CSV escaping chars
  26. Simple Random Samples from a MySQL Sql database
  27. Use Composite Primary Key as Foreign Key
  28. MySQL Select minimum/maximum among two (or more) given values
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment