Re: writing a query that returns similar numbers
| From: | mike cullerton | Date: | Wed, 04 Jul 2001 18:10:51 +0000 |
| Subject: | Re: writing a query that returns similar numbers | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56209@lists.php.net to get a copy of this message | ||
select rowid from numbers where number between mynumber-10 and mynumber+10;
on 7/4/79 10:48 AM, zerosumzero@yahoo.com at zerosumzero@yahoo.com wrote:
> I have a database with numbers in one of the tables I'd like to ask mysql to
> renturn all numbers with say 10 of mynumber
>
> Sort of like this:
>
> $sql = "SELECT rowid FROM numbers WHERE (mynumer is within 10 of number)";
>
>
> but I've gotten stuck do I have to do this:
>
>
> $sql = "SELECT rowid FROM numbers WHERE (((mynumer+10) < number) AND
> (mynumer-10) > number) )";
>
> it seems kinda wordy ...
>
> Susan
>
-- mike cullerton