consulta restando

[huesos52]

Mira este ejemplo

Código MySQL:

mysql> select *from limite5;
+------+
| hola |
+------+
| 1970 |
| 1972 |
| 1985 |
| 1989 |
+------+
4 rows in set (0.00 sec)
 
mysql> select *from limite5 where hola between (1970-5) and (1970+5);
+------+
| hola |
+------+
| 1970 |
| 1972 |
+------+
2 rows in set (0.00 sec)
 
mysql> select *from limite5 where hola between (1980-5) and (1980+5);
+------+
| hola |
+------+
| 1985 |
+------+
1 row in set (0.00 sec)
 
mysql> select *from limite5 where hola between (1990-5) and (1990+5);
+------+
| hola |
+------+
| 1985 |
| 1989 |
+------+
2 rows in set (0.00 sec)
 

Donde se muestran los años 1970, 1980 y 1990 sería el dato de entrada a comparar.

saludos