SQLite Forum

Word search in FTS5
Login
Anyone got any hints for how to do a word-search query in FTS5 ? 

Basically I want the results to match the start of words, so if I present 's' as the input, then I only get back rows that have words starting with 's'. If I then present 'st' as the input, I only get back words starting with 'st' etc.

I tried presenting ' s', but of course the tokenizer strips out the ' ' character, so that won't work.