MySQL Boolean Full-Text Searches: Change Default Operator to "and"
By default (when neither + nor - is specified) the word is optional
How can I change this behavior to:
All words are required -> logical AND search
SELECT * FROM articles WHERE MATCH (title) AGAINST ('MySQL Tricks' IN BOOLEAN MODE);
should only find id 4,
SELECT * FROM articles WHERE MATCH (title) AGAINST ('+MySQL +Tricks' IN BOOLEAN MODE);
Note the + prefix on each word that is 'required'. The '+' is not a 'binary operator'.