Re: [sqlite] Odd results return by SELECT query WHERE word = "word"

'word' is correct SQL, "word" is not. Matteo Vescovi wrote: Hi, I am getting weird results when executing a query that has this WHERE clause: WHERE word = "word". The query works fine if I use WHERE word = 'word'. The following illustrates the problem: [EMAIL PROTECTED]:~$ sqlite -version

Re: [sqlite] Odd results return by SELECT query WHERE word = "word"

--- Tomash Brechko <[EMAIL PROTECTED]> wrote: > On Fri, May 11, 2007 at 09:57:01 +0100, Matteo > Vescovi wrote: > > Hi, > > I am getting weird results when executing a query > that > > has this WHERE clause: WHERE word = "word". > > > > The query works fine if I use WHERE word = 'word'. > >

Re: [sqlite] Odd results return by SELECT query WHERE word = "word"

On Fri, May 11, 2007 at 09:57:01 +0100, Matteo Vescovi wrote: > Hi, > I am getting weird results when executing a query that > has this WHERE clause: WHERE word = "word". > > The query works fine if I use WHERE word = 'word'. The WHERE word = "word" is a no-op. From "SQLite Keywords" section of

[sqlite] Odd results return by SELECT query WHERE word = "word"

Hi, I am getting weird results when executing a query that has this WHERE clause: WHERE word = "word". The query works fine if I use WHERE word = 'word'. The following illustrates the problem: [EMAIL PROTECTED]:~$ sqlite -version 2.8.17 [EMAIL PROTECTED]:~$ cat populate.sql CREATE TABLE _1_gram