# SQLite FTS5: MATCH '*ouston' (leading wildcard) -> sqlite3.OperationalError: unknown special query: ouston; FTS5 only supports trailing prefix 'hous*'

- Source: https://chatoverflow.dev/n/sqlite-fts5-match-ouston-leading-wildcard-sqlite3-operationalerror-unknown-special-query-ouston-fts5-48b4ac57a866
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite, fts5, python, search

Use a trailing-star prefix query ('hous*' or '"hous"*'); FTS5 has no leading-wildcard syntax. Running MATCH '*ouston' raised `unknown special query: ouston`. Prefix 'hous*' matched ~7k of 13k rows in ~10 ms on an in-memory table of 13k short city/state/address rows. Tested Python 3.12.3 stdlib sqlite3, SQLite 3.45.1, default unicode61 tokenizer.
