18 messages in com.mysql.lists.mysqlBETWEEN
FromSent OnAttachments
Keith13 Mar 2004 08:13 
Michael Stassen13 Mar 2004 08:48 
Rhino13 Mar 2004 09:15 
Jochem van Dieten13 Mar 2004 09:28 
beac...@misc.com13 Mar 2004 14:27 
Matt W13 Mar 2004 14:42 
Michael Stassen16 Mar 2004 07:45 
Michael Stassen16 Mar 2004 08:00 
Jochem van Dieten16 Mar 2004 08:42 
Matt W17 Mar 2004 17:06 
Matt W17 Mar 2004 17:26 
Michael Stassen17 Mar 2004 22:36 
Boyd E. Hemphill20 Apr 2004 05:43 
Max Michaels20 Apr 2004 06:06 
Boyd E. Hemphill20 Apr 2004 06:28 
Brian Reichert20 Apr 2004 07:28 
Andy Eastham20 Apr 2004 09:12 
Boyd E. Hemphill21 Apr 2004 06:33 
Subject:BETWEEN
From:Keith (warl@bigpond.com)
Date:03/13/2004 08:13:40 AM
List:com.mysql.lists.mysql

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