Have you tried connecting the 'between' clauses with 'OR'? Like this:
select * from table where sector_id between 1 and 20 or sector_id between 30 and 42 This approach works in my 4.0.15 MySQL database. Rhino ----- Original Message ----- From: "Keith" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Saturday, March 13, 2004 11:14 AM Subject: BETWEEN g'day, i'm looking for a way to do two BETWEEN ranges. Currently I have sys.sectorID BETWEEN 1 AND 20 but I want it so that I can search between 1 and 20 and also between 30 and 42 but all my efforts net an error and the manual doesn't go into a lot of detail. If there's a faster way than BETWEEN then 'll take it. Cheers, Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
