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: syntax error near “"
Since I am doing these queries in a program, and I can’t predict what
characters might be present in my search term, how can I properly escape the
query so the following works (showing JavaScript syntax below)
function res(q) {
const s = 'SELECT Count(id) AS c FROM t JOIN v ON t.id = v.id WHERE v
MATCH ?’;
return db.prepare(s).get(q);
}
res('Trematoda (awaiting allocation)’);
--
Puneet Kishor
Just Another Creative Commoner
http://punkish.org/About
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
