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 sentence using fts4( content text );
> sqlite> inser
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( 'FTS3 and FTS4 are nearly i
On Mon, 25 Mar 2013 17:46:17 -0400,
wrote:
>I installed slqite, its sqlite3 command line interface, and a GUI admin
>console. Have built and populated a couple of databases. But what I really
>want to do is to connect to sqlite databases from Visual Studio 2012 using
>Visual Basic.
>
>Downloade
Try this:
SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE
CONCAT('%',T2.Terms,'%')
Paul
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson
Sent: Tuesday, March 26, 2013 10:27 AM
To: General Discussion of SQLi
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 course this does not work):
SELECT [S
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] LIKE (SELECT Terms FRO
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 [Sentences] FROM [T1] WHERE
Rob, no that does not work either.
Thanks for trying though.
2013/3/26 Rob Richardson :
> 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.or
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-boun...@sqlite.org]
On Behalf Of Gert Van Assche
Sent: Tuesday, March 26, 2013
Hi All,
My application's(32 bit application) runtime prerequisite is .Net4.0. It
uses the SQlite database.I am shipping System.Data.SQLite.dll (product
version: 1.0.74). This setup works fine in Windows 7. But in Windows XP the
same file System.Data.SQLite.dll is not able to connect to the SQLite
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 table.
>> Something like t
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 T2.Te
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 Term
As I can see my problem is solved on sqlite 4.
Em 08/03/2013, às 16:35, Israel Lins Albuquerque
escreveu:
> Thank you guys, and sort for my bad explanation about what I want. I
> understand that double problems very well,
> I will continue working with round.
>
> Regards,
> Israel Lins
>
>
A table with two columns, both integers, one column primary key. I iterate
and insert 100,000 values. Then do 100,000 random updates.
On Tue, Mar 26, 2013 at 4:30 AM, Dan Kennedy wrote:
> On 03/26/2013 06:34 AM, Rob Turpin wrote:
>
>> Dan,
>>
>> I haven't heard anything more about this. I was
On 03/26/2013 06:34 AM, Rob Turpin wrote:
Dan,
I haven't heard anything more about this. I was wondering if you also
think the CPU performance for sqlite4 should be better? Maybe you could
help me with where I could focus my attention in looking into this. I know
that's probably a big questio
16 matches
Mail list logo