Nice
2013/3/26 Petite Abeille :
>
> On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" wrote:
>
>> SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE
>> CONCAT('%',T2.Terms,'%')
>
> Alternatively, use FTS [1]:
>
> sqlite> create virtual table
On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" wrote:
> SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE
> CONCAT('%',T2.Terms,'%')
Alternatively, use FTS [1]:
sqlite> create virtual table sentence using fts4( content text );
sqlite> insert into sentence values(
of SQLite Database
Subject: Re: [sqlite] looking up records with terms in a table
I think you need wildcards:
SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms%
RobR, not guaranteeing correct syntax
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users
Bingo!
Thanks you all!
2013/3/26 Clemens Ladisch :
> Gert Van Assche wrote:
>> 2013/3/26 Clemens Ladisch :
>>> Gert Van Assche wrote:
What I would like to do is look for all terms that appear in the Terms
table.
Something like this (but of
Gert Van Assche wrote:
> 2013/3/26 Clemens Ladisch :
>> Gert Van Assche wrote:
>>> What I would like to do is look for all terms that appear in the Terms
>>> table.
>>> Something like this (but of course this does not work):
>>> SELECT [Sentences] FROM [T1] WHERE [Sentences]
On Tue, 26 Mar 2013 17:14:57 +0100
Gert Van Assche wrote:
> SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE '%GM%';
>
> What I would like to do is look for all terms that appear in the
> Terms table. Something like this (but of course this does not work):
> SELECT
riginal Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche
> Sent: Tuesday, March 26, 2013 12:53 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] looking up records with terms in
, 2013 12:53 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] looking up records with terms in a table
Clemens, doesn't seem to work...
The terms are just a part of the sentence, not a full match.
Your query does find full matches.
thanks
gert
Clemens, doesn't seem to work...
The terms are just a part of the sentence, not a full match.
Your query does find full matches.
thanks
gert
2013/3/26 Clemens Ladisch :
> Gert Van Assche wrote:
>> What I would like to do is look for all terms that appear in the Terms
Gert Van Assche wrote:
> What I would like to do is look for all terms that appear in the Terms table.
> Something like this (but of course this does not work):
> SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE (SELECT Terms FROM T2);
SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE
All,
I don't know if I can do this.
I have a table T1 with Sentences and a table T2 with Terms.
If I want to find all Sentences with the term "GM" I search like this:
SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE '%GM%';
What I would like to do is look for all terms that appear in the
11 matches
Mail list logo