'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
--- 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'.
>
>
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
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
4 matches
Mail list logo