Consultas json en mysql

0

 

SELECT title,
JSON_EXTRACT(extra_fields,$[0].id),
JSON_EXTRACT(extra_fields,$[0].value),
JSON_EXTRACT(extra_fields,$[1].id),
JSON_EXTRACT(extra_fields,$[1].value),
JSON_EXTRACT(extra_fields,$[2].id),
JSON_EXTRACT(extra_fields,$[2].value),
JSON_EXTRACT(extra_fields,$[3].id),
JSON_EXTRACT(extra_fields,$[3].value),
extra_fields,introtext 
FROM regatta_k2_items 
WHERE trash=0 AND catid=40 AND language=es-ES
ORDER BY id DESC;

Fuente:

https://laraveles.com/como-usar-de-forma-correcta-el-campo-json-de-mysql/