writing a query that returns similar numbers
| From: | zerosumzero@yahoo.com | Date: | Wed, 04 Jul 1979 16:48:25 +0000 |
| Subject: | writing a query that returns similar numbers | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56200@lists.php.net to get a copy of this message | ||
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