SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE user_attributes ( additional JSON ); INSERT INTO user_attributes VALUES ('{"surname":"Петров","firsname":"Петр","lastname":"Петрович"}'); SELECT concat( JSON_UNQUOTE(json_extract(additional,'$.surname')), JSON_UNQUOTE(json_extract(additional,'$.firsname')), JSON_UNQUOTE(json_extract(additional,'$.lastname')) ) fullname FROM `user_attributes` ;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear