Boolean Mode

Boolean mode supports operators: + (must include), - (must exclude), * (wildcard), "..." (exact phrase).

Example

-- Must have "mysql", must NOT have "oracle"
MATCH(title, body) AGAINST('+mysql -oracle' IN BOOLEAN MODE)

-- Exact phrase
MATCH(title, body) AGAINST('"query optimization"' IN BOOLEAN MODE)

-- Wildcard
MATCH(title, body) AGAINST('optim*' IN BOOLEAN MODE)

SQL

Full Editor

Pro Tip

Boolean mode does not rank by relevance by default — add relevance score manually.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned