Page 1 of 1

Search a range given a numer?

Posted: Tue Aug 30, 2005 2:28 pm
by alwoodman
I am looking to seach a given range when presented with a single number. For example if I have the wind speed of 10 then need to query for range 5-15 (i.e. 10 +-5) within the database, anyone any ideas how'd I'd dynamically do this?

Posted: Tue Aug 30, 2005 2:46 pm
by feyd
Guessing MySQL: BETWEEN syntax.

Code: Select all

SELECT * FROM table WHERE field BETWEEN {$speed}-5 AND {$speed}+5