The Ultimate Guide to High Availability with MariaDB

Comments - JSON_EXTRACT

5 years, 4 months ago Ryan Leadenham
Re: JSON_EXTRACT

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.

 
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.