Re: [sqlite] IN operator hits
I apologize and thank Paul for his answer. In fact, what I really meant to ask was how to get the original hit values for a MATCH operation when using FTS4 with a Porter tokenizer. I'm not sure what I was thinking in asking this question - please disregard it. On Mon, Sep 17, 2012 at 4:28 PM, Igor Tandetnik wrote: > E. Timothy Uy wrote: > > Is there a way to figure out which of the terms in an IN operator > actually > > hit? > > I'm not sure I understand the question. What exactly are you trying to > achieve? I suggest you describe the problem you are trying to solve, rather > than your proposed half-of-a-solution. > -- > Igor Tandetnik > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] IN operator hits
E. Timothy Uy wrote: > Is there a way to figure out which of the terms in an IN operator actually > hit? I'm not sure I understand the question. What exactly are you trying to achieve? I suggest you describe the problem you are trying to solve, rather than your proposed half-of-a-solution. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] IN operator hits
On 17 September 2012 17:23, E. Timothy Uy wrote: > Is there a way to figure out which of the terms in an IN operator > actually hit? Perhaps making a temp table is the only way. Any help Do you mean... SELECT DISTINCT col FROM tbl WHERE col IN ('a', 'b', 'c', 'd'); Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] IN operator hits
Is there a way to figure out which of the terms in an IN operator actually hit? Perhaps making a temp table is the only way. Any help is much appreciated. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users