MariaDB [(none)]> select json_extract('{"b":true}','$.b')=1;
|
+------------------------------------+
|
| json_extract('{"b":true}','$.b')=1 |
|
+------------------------------------+
|
| 1 |
|
+------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> select json_value('{"b":true}','$.b')=1;
|
+----------------------------------+
|
| json_value('{"b":true}','$.b')=1 |
|
+----------------------------------+
|
| 0 |
|
+----------------------------------+
|
1 row in set, 1 warning (0.00 sec)
|
|
MariaDB [(none)]> show warnings;
|
+---------+------+------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------+
|
| Warning | 1292 | Truncated incorrect DOUBLE value: 'true' |
|
+---------+------+------------------------------------------+
|
1 row in set (0.00 sec)
|
|