Re: [sqlite] like, but not equal?

On Jul 24, 2004, at 1:32 AM, [EMAIL PROTECTED] wrote: sqlite> select count(*) from newsgroups where name = 'rec.arts.anime.fandom'; 0 sqlite> select count(*) from newsgroups where name like 'rec.arts.anime.fandom'; 1 Figured it out: I was using sqlite3_bind_blob(), but if I change to sql

RE: [sqlite] like, but not equal?

Le sam 24/07/2004 à 21:23, Steve O'Hara a écrit : > Also, LIKE doesn't use an index so don't expect great performance Well, although sqlite doesn't use an index, the performance of the like clause still is truly amazing to me. I'm talking hundreds of thousands of rows here, filled with pat

RE: [sqlite] like, but not equal?

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

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

Re: [sqlite] like, but not equal?

[EMAIL PROTECTED] wrote: I just finished translating my sqlite2 code into sqlite3 and, hey, it compiles! But it looks like I've still got some work ahead of me.. Here's my first question: what's going on here (from command line sqlite3)? sqlite> select count(*) from newsgroups where name = '