Also, LIKE doesn't use an index so don't expect great performance........ Steve
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 24 July 2004 19:14 To: [EMAIL PROTECTED] Subject: Re: [sqlite] like, but not equal? On Jul 24, 2004, at 2:45 AM, Paolo Vernazza wrote: > [EMAIL PROTECTED] wrote: > >> How can a string be like something that has no wildcards, but not >> equal to it? My hunch is it has something to do with character >> encoding, but is that really how it should work? > > Like is not case sensitive... Hey, I never knew that--I always did LOWER(foo) LIKE '%whatever%', unnecessarily. But the string in the database is definitely all lower-case. And, of course, when I try it again now it works correctly, the strings are equal and not just like. Ugh. -D
