-- Example JSON data in your table: -- {"text":"This is text value","image":"https:\/\/domain.com\/image.jpg"} -- Query 1 SELECT json_extract(jurnals.content, '$.text') from table_name -- Result: "This is text value" -- Query 2 SELECT json_extract(jurnals.content, '$.image') from table_name -- Result: "https://domain.com/image.jpg"