Re: [sqlite] NOT LIKE

On Oct 12, 2009, at 2:08 PM, Daniele Liscia wrote: > Does anybody know wether the "NOT LIKE" condition such as > > SELECT * FROM suppliers >WHERE supplier_name NOT LIKE '%blabla%'; > > works in sqlite? We have no reason to believe that it does not work. If you have evidence that suggests a p

Re: [sqlite] NOT LIKE

Try this instead: SELECT * FROM suppliers WHERE (NOT supplier_name LIKE '%blabla%'); RBS > Does anybody know wether the "NOT LIKE" condition such as > > SELECT * FROM suppliers > WHERE supplier_name NOT LIKE '%blabla%'; > > works in sqlite? > I used it in a query but it resulted in incon

[sqlite] NOT LIKE

Does anybody know wether the "NOT LIKE" condition such as SELECT * FROM suppliers WHERE supplier_name NOT LIKE '%blabla%'; works in sqlite? I used it in a query but it resulted in inconsistent data. Thanks ___ sqlite-users mailing list sqlite-users

Re: [sqlite] NOT LIKE statement

Wednesday, June 25, 2008 5:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] NOT LIKE statement You seemed to be expecting that name NOT LIKE 'InternetGatewayDevice.%.[1-9]' AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] would exclude some of the rows you a

Re: [sqlite] NOT LIKE statement

"P Kishor" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You are expecting the LIKE (or NOT LIKE) operator to behave like a > RegExp operator. No, it doesn't. It just has a single wildcard > specifier, the % sign. Two of them: % (a sequence of zero or more of arbitrary characters)

Re: [sqlite] NOT LIKE statement

f Of Simon Davies > > Sent: Wednesday, June 25, 2008 4:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement > > I can get your expected results from the data you have given, as shown > below: > >

Re: [sqlite] NOT LIKE statement

n detail? >Thank you. > > James > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 4:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] NOT LIKE statement >

Re: [sqlite] NOT LIKE statement

lto:[EMAIL PROTECTED] On Behalf Of Simon Davies Sent: Wednesday, June 25, 2008 4:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] NOT LIKE statement I can get your expected results from the data you have given, as shown below: sqlite> CREATE TABLE tst( name text ); sqlite>

Re: [sqlite] NOT LIKE statement

entServer. sqlite> Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > I will read that. > But I want to know that is it possible to get the expected result? > Thank you. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]

Re: [sqlite] NOT LIKE statement

: [sqlite] NOT LIKE statement Hi James, I think the problem lies with your expectations. Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > > I execute the SQL statement [SELECT Name FROM tr06

Re: [sqlite] NOT LIKE statement

Hi James, I think the problem lies with your expectations. Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > > I execute the SQL statement [SELECT Name FROM tr069;] and get the result > > InternetGatewayDevice.

[sqlite] NOT LIKE statement

Hi, I execute the SQL statement [SELECT Name FROM tr069;] and get the result InternetGatewayDevice.DeviceInfo. InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion InternetGatewayDevice.DeviceInfo.Description InternetGatewayDevice