SQL Mode

SQL Mode is a Function that returns the frequent occurring value of a numeric expression. When there are no duplicate values in the records, the mode returns NA.

Understand with Example

To understand the example we use the following query that include a set of string value in a normal  mode. The Query result in 0 (false for the condition), when the 1 is not present between -5 and 5. Otherwise it returns 1 (true for the condition), if it exists between -5 and 5.

mysql> SET sql_mode = '';
Query OK, 0 rows affected (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  1 BETWEEN -5 AND 5;
+--------------------+
| 1 BETWEEN -5 AND 5 |
+--------------------+
| 1                  |
+--------------------+
1 row in set (0.00 sec)