This should work too:
$sql = "SELECT rowid FROM numbers WHERE ABS(number - mynumber) <= 10";
-Original Message-
From: Chris Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 1:24 PM
To: [EMAIL PROTECTED]; PHP Mailingliste
Subject: Re: [PHP] writing
select rowid from numbers where number between mynumber-10 and mynumber+10;
on 7/4/79 10:48 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] 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:
>
>
Try the LIKE wording in your statement. That should workI think
- Original Message -
From: <[EMAIL PROTECTED]>
To: "PHP Mailingliste" <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 1979 12:48 PM
Subject: [PHP] writing a query that returns similar numbers
> I have a database with numbe
3 matches
Mail list logo