Re: [sqlite] escaping search terms in queries with bind params

On 7/8/62 13:50, P Kishor wrote: Using FTS5 (sqlite3 3.29.x), the following works SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda awaiting allocation’; but the following fails SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda

[sqlite] escaping search terms in queries with bind params

Using FTS5 (sqlite3 3.29.x), the following works > SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda > awaiting allocation’; but the following fails > SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v MATCH 'Trematoda > (awaiting allocation)’; Error: fts5: