[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] FTS5 performance problem.
From:       Clemens Ladisch <clemens () ladisch ! de>
Date:       2017-05-28 13:43:30
Message-ID: 8c58cb77-1554-3674-71e0-cd510de961bf () ladisch ! de
[Download RAW message or body]

John Found wrote:
> Pseudocode: ?1 = keyword + ' ThreadID:' + num2str(threadID);
>
> select count() from PostFTS where PostFTS match ?1;

That works.

> ?1 = keyword
> ?2 = threadID
> select count() from PostFTS where PostFTS match ?1 ThreadID:?2;

That is not valid SQL.  You have to create a single SQL string:

  select count(*) from PostFTS where PostFTS match ?1 || ' ThreadID:' || ?2;


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]