notice the difference, because
your usage is an unusual construct. IMHO, anyway.
> -Original Message-
> From: Ed Smith [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 03, 2003 7:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Why does mySQL violate NOT precedence?
>
>
Your point does not seem relevant to my question on
mySQL compliance with the specification. In fact,
your response doesn't even mention the specification.
Perhaps I'm misunderstanding your question. You are
wondering why I would ask a query like
SELECT *
FROM Person
WHERE NOT name = 'Bob'?
Mi
I'm not sure why you would use the syntax you are trying to use. I
think you are making a few assumptions that may be incorrect. If you do
this query:
SELECT not name='Bob' FROM person
You'll see your result is set contains all 0's. Records where
name='Bob' would return 1, but you are taking the
