SQLite Forum

Difference between MATCH('x') and MATCH('x*')
I think the confusion stemmed from the snippet() function, which highlights *any* occurrence of 'x' in the string, not just the ones that the query matches. So I'm seeing highlighting of the X in 'my xylophone is broken' as well as 'x marks the spot', even when searching for just 'x'