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]