Re: Searching within a range
| From: | 1LT John W. Holmes | Date: | Fri, 28 Jun 2002 14:04:36 +0000 |
| Subject: | Re: Searching within a range | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104328@lists.php.net to get a copy of this message | ||
From: "Jason Wong" <php-general@gremlins.com.hk>
> select * from table where price > 0 AND price < 50;
SELECT * FROM table WHERE price BETWEEN 0 AND 50;
Same thing, easier to read (assuming MySQL, don't know if it works on
others).
---John Holmes...