DEV Community

Tim Nguyen
Tim Nguyen

Posted on • Edited on

MySQL syntaxes

#syntaxes #mysql

What

👎 JSON_UNQUOTE + JSON_EXTRACT vs 👍 ->>




SELECT JSON_UNQUOTE(JSON_EXTRACT(metadata, 'field')) 👎

SELECT metadata->>'$.field' 👍
Enter fullscreen mode Exit fullscreen mode




Why it matters?

JSON_EXTRACT vs -> only return the json result
JSON_UNQUOTE + JSON_EXTRACT vs ->> return the parsed result (you can think of the JSON.parse method in JS)

Top comments (0)

Read next

xxzeroxx profile image

MySQL Terminal: Alter table, charset and delete

Antonio Silva -

adityabhuyan profile image

Best Practices for Handling Sensitive Data in MySQL Databases

Aditya Pratap Bhuyan -

adityabhuyan profile image

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Aditya Pratap Bhuyan -

grahamthedev profile image

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

GrahamTheDev -