PHP with MySQL WHERE Value Range

Question

So, I have a variable with a certain integer. Let's call it $num. What I'd like to do is to check in a table called nums where I have value(s) between or equal to $num-2 and $num+2 but not equal to $num.

Mathematically, this range would be like [$num-2,$num[ ; ]$num,$num+2].

SELECT num FROM nums WHERE ...

I know this is basic querying but I'm kind of confused right now. Thanks in advance.

Marc B · Accepted Answer · 2013-03-31 20:08:38Z

2

SELECT ...
...
WHERE nums (BETWEEN ($num - 2) AND ($num + 2))
   AND (nums <> $num)

answered Mar 31, 2013 at 20:08

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

FábioMartinho Over a year ago

Does BETWEEN include $num-2 and $num+2? Or is it like $num-2<x and x<$num+2?

Marc B Over a year ago

X between A and B is the equivalent of (A <= X) && (X <= B).

FábioMartinho Over a year ago

Ok, thanks. I'll accept your answer in 6 minutes since it doesn't allow me to do it now.

Collectives™ on Stack Overflow

PHP with MySQL WHERE Value Range

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related