MySql JSONObject Ifnull

Question

I am working on Mysql query to retrieve the JSON Object

Select JSON_OBJECT('id', students.id, 'name', students.name) as test from students;

output


         "test": {
            "id": null,
            "name": null
          }

expected output

test: null

How can i check if test object has a null values then return null

Your "expected output" is not valid JSON. From the looking point of MySQL at least. — Akina
– Akina, Commented Apr 20, 2021 at 10:22

Akina · Accepted Answer · 2021-04-20 10:26:05Z

1

How can i check if test object has a null values then return null

Formally (without understanding the logic):

SELECT CASE WHEN students.id IS NULL AND students.name IS NULL
            THEN CAST( 'null' AS JSON )
            ELSE JSON_OBJECT('id', students.id, 'name', students.name) 
            END AS test 
FROM students;

answered Apr 20, 2021 at 10:26

Akina

43.2k6 gold badges17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySql JSONObject Ifnull

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related