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.DeviceInfo. > > InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion > > InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion > > InternetGatewayDevice.DeviceInfo.Description > > InternetGatewayDevice.DeviceInfo.DeviceLog > > InternetGatewayDevice.DeviceInfo.DeviceStatus > > InternetGatewayDevice.DeviceInfo.EnabledOptions > > InternetGatewayDevice.DeviceInfo.FirstUseDate > > InternetGatewayDevice.DeviceInfo.HardwareVersion > > InternetGatewayDevice.DeviceInfo.SoftwareVersion > > InternetGatewayDevice.DeviceInfo.Manufacturer > > InternetGatewayDevice.DeviceInfo.ManufacturerOUI > > InternetGatewayDevice.DeviceInfo.ModelName > > InternetGatewayDevice.DeviceInfo.ProductClass > > InternetGatewayDevice.DeviceInfo.ProvisioningCode > > InternetGatewayDevice.DeviceInfo.SerialNumber > > InternetGatewayDevice.DeviceInfo.UpTime > > InternetGatewayDevice.ManagementServer. > > InternetGatewayDevice.ManagementServer.URL > > InternetGatewayDevice.ManagementServer.Username > > InternetGatewayDevice.ManagementServer.Password > > InternetGatewayDevice.ManagementServer.PeriodicInformEnable > > InternetGatewayDevice.ManagementServer.PeriodicInformInterval > > InternetGatewayDevice.ManagementServer.PeriodicInformTime > > InternetGatewayDevice.ManagementServer.ParameterKey > > InternetGatewayDevice.ManagementServer.ConnectionRequestURL > > InternetGatewayDevice.ManagementServer.ConnectionRequestUsername > > InternetGatewayDevice.ManagementServer.ConnectionRequestPassword > > InternetGatewayDevice.ManagementServer.UpgradesManaged > > InternetGatewayDevice.ManagementServer.KickURL > > InternetGatewayDevice.ManagementServer.DownloadProgressURL > > > > And I execute the SQL statement [SELECT name FROM tr069 WHERE name LIKE > 'InternetGatewayDevice.%' AND name NOT LIKE 'InternetGatewayDevice.%.[1-9]' > AND name NOT LIKE 'InternetGatewayDevice.%.[^1-9] ';] and expect to get the > result [InternetGatewayDevice.DeviceInfo.] and > [InternetGatewayDevice.ManagementServer.]. > > But I still get the above result. I don't know where the problem is. > > Could someone tell me ? > > Thank you. > > > > James Liang > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users