Не работают - негры в африке.
Показывайте цитату с консоли сервера, доказывающую это утверждение.
Добавлено через 4 минуты и 5 секунд
Вот типа так:
| Код |
mysql> create table test(id int, val int);
Query OK, 0 rows affected (1.41 sec)
mysql> insert into test (id, val)
-> select 1,1 union all
-> select 2,10 union all
-> select 3,-2 union all
-> select 4,-10 union all
-> select 5,0 ;
Query OK, 5 rows affected (0.38 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from test;
+------+------+
| id | val |
+------+------+
| 1 | 1 |
| 2 | 10 |
| 3 | -2 |
| 4 | -10 |
| 5 | 0 |
+------+------+
5 rows in set (0.02 sec)
mysql> select * from test where val between -7 and -1;
+------+------+
| id | val |
+------+------+
| 3 | -2 |
+------+------+
1 row in set (0.00 sec)
mysql> select * from test where val between -7 and 2;
+------+------+
| id | val |
+------+------+
| 1 | 1 |
| 3 | -2 |
| 5 | 0 |
+------+------+
3 rows in set (0.00 sec)
|
|
)