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 numbers in
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:
$sql
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 a query that returns
3 matches
Mail list logo