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,

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

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] 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