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

mdarifulhaque profile image

Automated CSV and Excel Data Import to MySQL and PostgreSQL Databases Using PHP

MD ARIFUL HAQUE -

dm8ry profile image

Setting Up MySQL on Kubernetes with Prometheus & Grafana Monitoring

Dmitry Romanoff -

bladepipe profile image

How to Move Data From MySQL to Redis in Real Time

BladePipe -

sidyguedes profile image

PHP/MySQL/Nginx/Redis Application Docker

Sidgley de Almeida Guedes -