[sqlite] FTS: Escaping MATCH expressions

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 wit

[sqlite] FTS: Escaping MATCH expressions

On 09/09/2015 07:56 PM, Lohmann, Niels, Dr. (CQTN) wrote: > 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 myFtsT

[sqlite] FTS: Escaping MATCH expressions

FTS3/4 replaces non-alphanumeric characters with spaces. I do the same for strings that I match in my applications. Something like: preg_replace('/[^\*\da-z\x{0080}-\x{}]/ui', ' ', $string); On Wed, Sep 9, 2015 at 7:56 AM, Lohmann, Niels, Dr. (CQTN) wrote: > Hi there, > > I have a question r