Comments - JSON_EXTRACT
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
This function always returns a string which may include any JSON markup and escaping characters. For example:
SELECT JSON_EXTRACT( JSON_OBJECT('test', 'a"b') , '$.test') AS test;
Returns:
"a\"b"
This means that this function alone is not usable for comparison functions within SQL functions such as WHERE and JOIN statements.