link: http://www.sqlite.org/fts3.html#section_4_2
Section 4.2
The last statement of example:
SELECT snippet(text, '[ ']', '...') FROM text WHERE text MATCH '"min* tem*"'
Should be:
SELECT snippet(text, '[', ']','...') FROM text WHERE text MATCH '"min* tem*"'
to match explanation in the comment:
-- The following query returns the text value:
--
-- "...the upper portion, [minimum] [temperature] 14-16oC and cool elsewhere,
-- [minimum] [temperature] 17-20oC. Cold..."
--
Aleksander N. Dobrev
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
