help with sql statement

From: Date: Mon, 12 Jul 2010 15:24:35 +0000
Subject: help with sql statement
Groups: php.general 
Request: Send a blank email to php-general+get-306832@lists.php.net to get a copy of this message
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?

« previous php.general (#306832) next »