[Correction]
Change:
Also, reversing the order should work (since grouping is left-to-right):
To:
Also, reversing the order should work (since AND/OR/etc. are read
left-to-right):
- Jon L.
On Mon, Mar 10, 2008 at 4:18 PM, Jon L. <[EMAIL PROTECTED]> wrote:
> As much as I hate admitting to it at
As much as I hate admitting to it at this point...Neil did, at least, have
something right.
You'll want to be cautious of how you group your tests.
If you copy the variable for both tests, you may get:
> WHERE name LIKE "ABC" AND listing_type = 1 OR listing_type = 2
But, SQL can only compare 2 t
> Now I've spoon fed you
Damn, Neil...you're a d-bag.
Next time you go to offer "help," it may assist you to know that most people
don't respond well to being talked down to.
(obviously, I'm contradicting my own advice, here; but, I doubt you'll learn
from it, anyways)
Now, Ron...
I'm hoping th
At 19:34 09/03/2008, you wrote:
From: Ron Piggott <[EMAIL PROTECTED]>
Date: Sun, 09 Mar 2008 15:34:05 -0400
Message-Id: <[EMAIL PROTECTED]>
What is the correct syntax for where the results may be 1 or 2? What
have I done wrong?
SELECT * FROM table WHERE name LIKE "ABC" AND listing_type = 1 or
