RE: [PHP] writing a query that returns similar numbers
| From: | Matthew Loff | Date: | Wed, 04 Jul 2001 19:48:40 +0000 |
| Subject: | RE: [PHP] writing a query that returns similar numbers | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56224@lists.php.net to get a copy of this message | ||
This should work too:
$sql = "SELECT rowid FROM numbers WHERE ABS(number - mynumber) <= 10";
-----Original Message-----
From: Chris Anderson [mailto:chrisderson@ameritech.net]
Sent: Wednesday, July 04, 2001 1:24 PM
To: zerosumzero@yahoo.com; PHP Mailingliste
Subject: Re: [PHP] writing a query that returns similar numbers
Try the LIKE wording in your statement. That should work....I think
----- Original Message -----
From: <zerosumzero@yahoo.com>
To: "PHP Mailingliste" <php-general@lists.php.net>
Sent: Wednesday, July 04, 1979 12:48 PM
Subject: [PHP] writing a query that returns similar numbers
> 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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net To
> contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net To
contact the list administrators, e-mail: php-list-admin@lists.php.net