Yes... Does it work?
----- Original Message ----- From: "Bob Ramsey" <[EMAIL PROTECTED]> To: "Lingua2001" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:57 AM Subject: Re: "between A and B" with another condition? > Like this? > > mysql> select * from t2; > +---------+--------+ > | name | number | > +---------+--------+ > | bob | 3 | > | bob | 2 | > | bob | 1 | > | al | 1 | > | al | 2 | > | al | 3 | > | al | 4 | > | adam | 4 | > | adam | 3 | > | adam | 2 | > | charlie | 2 | > +---------+--------+ > 11 rows in set (0.00 sec) > > mysql> select * from t2 where (number <3) and (name between 'a' and 'c'); > +------+--------+ > | name | number | > +------+--------+ > | bob | 2 | > | bob | 1 | > | al | 1 | > | al | 2 | > | adam | 2 | > +------+--------+ > 5 rows in set (0.00 sec) > > Is that what you mean? > > > > > ====================================================================== > Bob Ramsey Applications Development & Support II > ph: 1(319)335-9956 216 Boyd Law Building > fax: 1(319)335-9019 University of Iowa College of Law > mailto:[EMAIL PROTECTED] Iowa City, IA 52242-1113 > For Hardware and Software questions, call 5-9124 > ====================================================================== > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]