Re: help with sql statement

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