SQL - JSON_ARRAY() in SQL

JSON_ARRAY() is a SQL function used to create a JSON array from one or more values. It is useful when you want to store or return multiple values in a single JSON array.

Syntax

JSON_ARRAY(value1, value2, value3, ...)

• Each value can be string, number, boolean, or JSON object
• Returns a valid JSON array

Example Table

CREATE TABLE users (

  id INT,

  name VARCHAR(50)

);

INSERT INTO users VALUES

(1, 'Ashok'),

(2, 'Rohan');

Create JSON Array

SELECT JSON_ARRAY('SQL', 'CSS', 'JavaScript') AS skills;

Result:

skills

------------------------

["SQL", "CSS", "JavaScript"]

Combine with Table Data

SELECT name, JSON_ARRAY('SQL', 'CSS', 'JavaScript') AS skills

FROM users;

Result:

name     skills

-----------------------------

Ashok   ["SQL", "CSS", "JavaScript"]

Rohan    ["SQL", "CSS", "JavaScript"]

Key Points

• Creates arrays in JSON format
• Can be combined with JSON_OBJECT() to create nested JSON
• Useful for APIs, data export, and dynamic data storage