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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users