Hi there, ? I have a question regarding the expressions that are valid after MATCH: Is there a way to escape a string str such that I can safely bind it to variable @var in a statement like "SELECT * FROM myFtsTable WHERE myFtsTable MATCH @var;"? ? In particular, I encountered error messages with strings like "TEST.*" or "TEST'*". ? All the best Niels
- [sqlite] FTS: Escaping MATCH expressions Lohmann, Niels, Dr. (CQTN)
- [sqlite] FTS: Escaping MATCH expressions Dan Kennedy
- [sqlite] FTS: Escaping MATCH expressions Martin Kucej