Natural Language vs Boolean Mode
Learn Natural Language vs Boolean Mode (Full-Text Search, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Natural language mode (the default) treats the query as free text: any word may match and rows are ranked by relevance. Boolean mode ( IN BOOLEAN MODE ) lets you write rules with operators: + must contain, - must not contain, * prefix wildcard, "..." exact phrase, > and < raise or lower a word's weight, and ( ) grouping.