SQL

select item.* as json mysql

-- You can't use * in json selects in all version of mySQL, but you can 
-- outline all fields you want in a select statement as follows: 
SELECT contact.*, JSON_OBJECT(
  'name_field', name_field,
  'address_field', address_field,
  'contact_age', contact_age
) AS location
FROM contact
JOIN location on contact.loc_id = location.id;

-- You may be able to use "JSON_ARRAYAGG()" for this in mySQL 8+

mysql json get value

SELECT JSON_EXTRACT('{"a": 1, "b": 2, "c": 3}', '$.b') AS 'Result';

how select a json value in mysql

SELECT * FROM table WHERE JSON_CONTAINS(name, '["key"]');