Why json_object start with comma?

Databases
1

Hi I’ve got the following code:

CONCAT('[',
                GROUP_CONCAT(CASE
                             WHEN buildings_join.permission = '1'
                             THEN JSON_OBJECT('buildingName',
                                               buildings.building_name,
                                               'buildingID',
                                                buildings.building_id)
                             ELSE '' END ),
         ']') AS user_buildings

when I’ve got only one value in the database I get the following

[,{"buildingID": 2, "buildingName": "Via umberto"}]

If I’ve got two values then I get the following:

[{"buildingID": 1, "buildingName": "Via roma"},{"buildingID": 2, "buildingName": "Via umberto"}]

Now how can I remove the comma after [ when I’ve only got one value? many thanks

2

why does that comma after the square bracket disappear if there are two values?

3

Hi @r937 i’ve got no idea. I’ve sorted it out with php at the moment.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.