Search a range given a numer?
Moderator: General Moderators
Search a range given a numer?
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?
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Guessing MySQL: BETWEEN syntax.
Code: Select all
SELECT * FROM table WHERE field BETWEEN {$speed}-5 AND {$speed}+5