Ah, that works just fine. Is this noted someplace in the documentation that I missed? If not: - why does it work with single quotes and not double? - Shouldn't it be added?
This is all I found on the "Datatypes in SQLite Version 3" page: "Values specified as literals as part of SQL statements are assigned storage class TEXT if they are enclosed by single or double quotes, ..." But it works, and that's what matters. Thanks! -> Steve -----Original Message----- From: Scott Leighton [mailto:[EMAIL PROTECTED] Sent: Saturday, April 23, 2005 7:28 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] LIKE returns all rows On Saturday 23 April 2005 7:15 pm, steve wrote: > Assume a database table named Good has a column named "bob". > The following command will return ALL rows in the table regardless of > their > content: > > SELECT * FROM Good WHERE bob LIKE "bob"; > > Is this by design? If so, is there a workaround for this other than > attempting to name all columns in a table to be so unique as to never > be "LIKEd"? > Try SELECT * FROM Good WHERE bob LIKE 'bob'; Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-20a-default x86_64
