adding condition to mysql json query

Question

I have a simple query like this that go over my mysql records of certain table and gives me jsons out of each record:

SELECT json_object(
  'personId', p.id,
  'formalName', p.name,
  'country', p.country)
FROM person p;

but I formalName can be null, and I wanted to add a condition like

if p.name is null 'NoName' else p.name

is it possible?

Jorge Campos · Accepted Answer · 2018-12-27 22:20:04Z

2

Yeap change p.name to case when p.name is null then 'NoName' else p.name end at the end your query will be:

SELECT json_object(
  'personId', p.id,
  'formalName', case when p.name is null then 'NoName' else p.name end,
  'country', p.country)
FROM person p;

answered Dec 27, 2018 at 22:20

Jorge Campos

23.8k7 gold badges65 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

adding condition to mysql json query

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