Re: [sqlite] matching only part of a string

2007-03-28 Thread drh
"P Kishor" <[EMAIL PROTECTED]> wrote: > On 3/28/07, Lloyd K L <[EMAIL PROTECTED]> wrote: > > Hi, > > My table contains a text field called Name. Let the data be > > > > Name > > --- > > Abc > > abcd > > AB > > cab > > def > > > > I want to selcct all the rows which contains the term ab (not c

Re: [sqlite] matching only part of a string

2007-03-28 Thread P Kishor
On 3/28/07, Lloyd K L <[EMAIL PROTECTED]> wrote: Hi, My table contains a text field called Name. Let the data be Name --- Abc abcd AB cab def I want to selcct all the rows which contains the term ab (not case sensitive). How can I do this? SELECT name FROM table WHERE Lower(name) LIKE

Re: [sqlite] matching only part of a string

2007-03-27 Thread Dan Kennedy
On Wed, 2007-03-28 at 12:27 +0530, Lloyd K L wrote: > Hi, > My table contains a text field called Name. Let the data be > > Name > --- > Abc > abcd > AB > cab > def > > I want to selcct all the rows which contains the term ab (not case > sensitive). How can I do this? SELECT name FROM "My

[sqlite] matching only part of a string

2007-03-27 Thread Lloyd K L
Hi, My table contains a text field called Name. Let the data be Name --- Abc abcd AB cab def I want to selcct all the rows which contains the term ab (not case sensitive). How can I do this? Thanks in advance, Lloyd - This email was sent using Sq