On Mon, 2010-07-12 at 10:24 -0500, Adam wrote:
> I was google searching, and the only SQL mailing list I found is
> currently giving a 503 error, so I hope you don't mind me asking my SQL
> question here, since there are a lot of SQL gurus here. I am having a
> syntax problem:
>
> Instead of doing a query like this::
>
> select SMS_R_SYSTEM.Name from SMS_R_System where
> (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/ABC") or
> (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/XYZ")
>
> I'd like to shorten it in the where clause to:
>
> select SMS_R_SYSTEM.Name from SMS_R_System where
> (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/ABC",
> "example.com/COMPUTERS/MAIN CAMPUS/XYZ")
>
> But I'm getting a syntax error. Any idea why my SQL syntax isn't valid?
>
>
>
The short answer is your syntax isn't valid, which means that what
you've written isn't valid SQL :p
What I think you're looking for instead is something like this:
SELECT SMS_R_SYSTEM.Name FROM SMS_R_System WHERE
SMS_R_System.SystemOUName IN ("example.com/COMPUTERS/MAIN CAMPUS/ABC",
"example.com/COMPUTERS/MAIN CAMPUS/XYZ")
which lets MySQL compare the field against an array of different values
within the brackets.
Thanks,
Ash
http://www.ashleysheridan.co.uk
