RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
One another thing is how does reversing of value and column work,
i mean the internals of it. Does it create any temp table ...
No, it just scans all records one by one, and runs the test for each
record.
And i see the sqlite documentation of
IL PROTECTED]>
Date: Wednesday, August 29, 2007 7:57 pm
Subject: [sqlite] Re: BestMatch and SqliteStatment Clash
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Best match is "9854002656" among the 2 records.
Pls try this simple one.It will make it clear,
create table test
D]>
Date: Wednesday, August 29, 2007 8:18 pm
Subject: Re: [sqlite] Re: BestMatch and SqliteStatment Clash
> ragha,
>
> you want something to give you a 'best match'. The 'like' operator in
> the way you are using it does not do that, but it IS working as it
> should.
>
>
mail in error, please notify the sender by phone or email immediately
> and delete it!
>
> *
>
> - Original Message -
> From: Igor Tandetnik <[EMAIL PROTECTED]>
> Date: Wednesday, A
or email immediately and
delete it!
*
- Original Message -
From: Igor Tandetnik <[EMAIL PROTECTED]>
Date: Wednesday, August 29, 2007 7:57 pm
Subject: [sqlite] Re: BestMatch and SqliteStatment
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Best match is "9854002656" among the 2 records.
Pls try this simple one.It will make it clear,
create table test(t text);
insert into test values ('9');
insert into test values('98');
insert into test values('983');
insert into test
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Thx. I have modifed it to ?, but
Sqlite fails to get records for the below query. When debug it retuns
SQLITE_DONE. Pls help.
select * from 'tbl.7' where ? like column1 || '%' order by column1
desc limit 1;
Data is as below:
insert into 'tbl.7'
7 matches
Mail list logo