SQL · JSON functions

json_each

A table-valued function that expands a JSON array or object into rows.

sqlRunnable example sql course

Syntax

json_each(json)

Example

Open in the lab

SELECT value FROM json_each('["HTML","CSS"]');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.