With the following query I get results that contain the words "International" AND "Shipping" and I also get results that contain "International" OR "Shipping". What can I do to ensure that the results contain both words and not just one of them?
Any help would be greatly appreciated, thanks!
SELECT client_company,client_description,client_keywords
FROM tb_clients
WHERE
MATCH (client_company,client_description,client_keywords)
AGAINST ('International Shipping') > 0
LIMIT 10
解决方案
Add a + in front of every required word and use IN BOOLEAN MODE.
In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which
+ stands for AND
- stands for NOT
[no operator] implies OR