Sotomajor.org.ua

Be aware that default precedence of NOT operator in MySQL 5 was decreased. Found it during one bugfix and if I knew that before, life could be much easier :-)

mysql> select version();
+-------------------+
| version()         |
+-------------------+
| 5.1.37-1ubuntu5.1 |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT NOT 1 BETWEEN -5 AND 5;
+------------------------+
| NOT 1 BETWEEN -5 AND 5 |
+------------------------+
|                      0 |
+------------------------+
1 row in set (0.00 sec)

------------------------------------------------------

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 4.1.22-standard-log |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT NOT 1 BETWEEN -5 AND 5;  
+------------------------+
| NOT 1 BETWEEN -5 AND 5 |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)

Further reading about:

• how to make NOT precedence in 5.1 to work same way as in 4;
• precedence in MySQL 4.1;
• precedence in MySQL 5.1.