Page 1 of 1

SELECT -/+ Number

Posted: Tue Jan 15, 2008 6:07 am
by mikeeeeeeey
What SQL do I use to see if a number is within plus or minus a number?

Say -/+ 10 with 10 as the start point

Would retrive: 7,13,1

but not: 21, -5


???

Thanks in advance

Re: SELECT -/+ Number

Posted: Tue Jan 15, 2008 6:34 am
by VladSun
[sql]SELECT a FROM TABLE WHERE a BETWEEN $start_point - $interval AND $start_point + $interval[/sql]

Re: SELECT -/+ Number

Posted: Tue Jan 15, 2008 6:48 am
by mikeeeeeeey
Thanks, it seems really silly now I think about it. ah well

Is there any way do something similar to explode() in SQL?

Re: SELECT -/+ Number

Posted: Tue Jan 15, 2008 7:33 am
by VladSun
The closest one I am to able find is http://dev.mysql.com/doc/refman/5.0/en/ ... nction_elt