range question for db query
| From: | Jon Rosenberg | Date: | Wed, 13 Dec 2000 05:03:28 +0000 |
| Subject: | range question for db query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30022@lists.php.net to get a copy of this message | ||
if i have a column in mysql that holds an age, and I want to send a query to
mysql that says retrieve the record if age is between 10 and 20, how do I
construct that query and use it with other search options, also..like below?
select * from table where age = (>9 and <21) and sex = male..etc
Thanks!
Jon