---
title: "Discussion on \"Get Started With JSON_ARRAY() in MySQL\" | Hashnode"
description: "Discussion on \"Get Started With JSON_ARRAY() in MySQL\". JSON_ARRAY()\nMySQL provides this function to return a list of values in array format.\nSELECT JSON_ARRAY(1,2,3);\nSELECT JSON_ARRAY(1,'cherish','');\nSELECT JSON_ARRAY();\nSELECT JSON_ARRAY(1,'public',NULL);\n\n\nNote: Even NULL value can be inserted into t..."
url: "https://hashnode.com/posts/get-started-with-jsonarray-in-mysql/6302216f428d2725de1a8900"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Get Started With JSON\_ARRAY() in MySQL](https://csachdeva83.hashnode.dev/get-started-with-jsonarray-in-mysql?utm_source=hashnode&utm_medium=feed)

JSON\_ARRAY() MySQL provides this function to return a list of values in array format. SELECT JSON\_ARRAY(1,2,3); SELECT JSON\_ARRAY(1,'cherish',''); SELECT JSON\_ARRAY(); SELECT JSON\_ARRAY(1,'public',NULL); Note: Even NULL value can be inserted into t...

Aug 21, 2022 · 2 min read · csachdeva83.hashnode.dev  
Read the article

-   [#mysql](https://hashnode.com/tag/mysql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#blogswithcc](https://hashnode.com/tag/blogswithcc)

## Written by

[Cherish Sachdeva](https://hashnode.com/@csachdeva83)

@csachdeva83 · Delhi, India

  
[View profile](https://hashnode.com/@csachdeva83)

Full Stack Developer 👨‍💻 | Documenting 📝my learnings | Coffeeholic ☕ | Voice for the Voiceless 🐕

I am a quick, adaptable learner who is not afraid to pick up a new tech stack or programming language. I have a good conceptual understanding of the fundamentals and am always eager to dive deep into unexplored territories. Outside of tech, I am an animal activist and have always stood as the voice for the voiceless, and in my spare time, I play football.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
