xxxxxxxxxx
-- 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"