Ok thanks. Charlie
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of HOPE 4 BEST Sent: 22 May 2008 08:35 To: [email protected] Subject: Re: [php_mysql] Concise select I think no. Regards Rider. (http://phpinterviewanswers.blogspot.com/) On Thu, May 22, 2008 at 12:37 PM, Charlie Markwick <[EMAIL PROTECTED]> wrote: > Is there a more concise way of expressing the following select:- > > SELECT * FROM maintable where Owner = 2 or Contact = 2 or > AccountsContact = 2 or Owner = 3 or Contact = 3 or AccountsContact = 3 > or Owner = 4 or Contact = 4 or AccountsContact = 4 ORDER BY DomainName > ASC; >
