[GENERAL] Expression matching related question

2006-04-09 Thread Peter Hoskin
eft=0. Can't seem to figure the syntax. Help would be appreciated. Regards, Peter Hoskin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so tha

Re: [GENERAL] Expression matching related question

2006-04-09 Thread Peter Hoskin
I should of mentioned, left is a bigint and network is an integer Peter Hoskin wrote: Hi, I wish to do a query such as: SELECT * FROM table WHERE column='something' AND column2='something else' AND (network='0' OR (left=0 AND network>0)); However, when I ex