iosfts5

Sqlite FTS5 punctuation marks not working in select query


I'm doing full text search using sqlite and below are some select query examples that I'm using.

Ex:

  1. SELECT * FROM table WHERE table MATCH 'column:father's' ORDER BY rank;

  2. SELECT * FROM table WHERE table MATCH 'column:example:' ORDER BY rank;

  3. SELECT * FROM table WHERE table MATCH 'column:month&' ORDER BY rank;

Since i'm using ' : & characters within the search text, these queries are giving me errors. I have tried using escape characters(\-backslash) before the puncuation marks as well.

Any solution to search the punctation marks(, . / " ' - & etc.) in fts5 with the MATCH operator?

These characters are working _, €, £, ¥ with the match operator

Thanks


Solution

  • This seems to be a duplicate of this question. Try the top answer there that states you should enclose your search string within both single and double quotes.