Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Note

Historical context on why Boolean mode was out of scope for the initial implementation:

  • The MySQL documentation does not clearly explain when to use different full-text search modes.

  • The team chose the default ("out-of-the-box") full-text search implementation for simplicity.

  • Boolean mode was not used due to several drawbacks:

    • It does not automatically sort results by relevance, requiring extra work to compute and apply relevance scores manually.

    • Using Boolean mode would require extending the query parser to support its custom syntax.

    • Implementing these changes would have added significant complexity without a clear path to automation.

  • The default mode already handles relevance sorting automatically, which met user needs with less effort.

...

🔤 Phrase Matching ("word1 word2")

...