RE: [PHP] writing a query that returns similar numbers

2001-07-04 Thread Matthew Loff
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

Re: [PHP] writing a query that returns similar numbers

2001-07-04 Thread mike cullerton
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: > >

Re: [PHP] writing a query that returns similar numbers

2001-07-04 Thread Chris Anderson
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