Re: Idea as to why this query won't work as expected?
| From: | Thomas Lamy | Date: | Tue, 05 Nov 2002 14:40:35 +0000 |
| Subject: | Re: Idea as to why this query won't work as expected? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22992@lists.php.net to get a copy of this message | ||
Dave Smith [mailto:DavidSmith@byu.net] wrote:
>
> I can never remember whether SQL is left-to-right, right-to-left, or
> some other deviant. Using parens is a sure way to guarantee that your
> statements are processed in the order you desire.
>
> --Dave
>
It's easy if you remember: AND is equal to multiplication, OR is equal to
addition. Multiplications are done before additions, so ANDs are done before
ORs.
Thomas