This series of tutorials covers the following topics:

  • Introduction to FTS3/FTS5
    • What is full-text search?
    • Use cases in applications
  • Setting Up Full-Text Search
    • Creating virtual tables for FTS
    • Configuring tokenizer and language settings
  • Executing Full-Text Queries
    • Using the MATCH operator
    • Ranking and highlighting search results
  • Advanced FTS Features
    • Prefix searches
    • Stemming and stop-words