Re: [sqlite] NOT LIKE statement

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 are getting. This is incorrect. The only wild cards affecting

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

Re: [sqlite] NOT LIKE statement

es > > 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> CRE

Re: [sqlite] NOT LIKE statement

mes > -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 > > I can get your expected results from th

Re: [sqlite] NOT LIKE statement

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> sqlite&g

Re: [sqlite] NOT LIKE statement

is it possible to get the expected result? > Thank you. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies > Sent: Wednesday, June 25, 2008 3:57 PM > To: General Discussion of SQLite Database > Subject: Re: [

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

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 > >

[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