Hi there! I'm working with a FTS5 query like this: SELECT rowid FROM text_fts_index WHERE text MATCH ?
The parameter is something like this: "user input"* The idea here is to do a MATCH prefix-type query in FTS5. The problem with this query is that it breaks if the user input contains double quotes. What I want to do is something like this: SELECT rowid FROM text_fts_index WHERE text MATCH "?"* This 2nd version of the query doesn't appear to work though because the ? is escaped in the quotes and doesn't appear to be recognized as a variable. Is there a way I'm missing to do this kind of MATCH prefix query and only escape the user input? Thanks! Ben _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
