mysql to json

[Destramic]

hey guys im trying to get this query working but im getting an error if anyone could tell me whats going wrong please....thank you

 

SELECT 
     CONCAT("[",
          GROUP_CONCAT(
               CONCAT("{platform_abbreviation:'", gp.platform_abbreviation,"'"),
               CONCAT(",game_name:'", g.game_name),
               CONCAT(",game_abbreviation:'", g.game_abbreviation),"'}")
          )
     ,"]") 
AS json
FROM game_platform_mappings gpm
LEFT JOIN game_platforms gp ON gp.game_platform_id = gpm.game_platform_id
LEFT JOIN games g ON g.game_id = gpm.game_id

 

error im getting

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS json FROM game_platform_mappings gpm LEFT JOIN game_platforms gp ON gp.gam' at line 8

[trq]

This would be much easier to do if you simply get the data out as normal then use json_encode. this way you'll also be able to reuse your queries.

[fenway]

Or this.

[Destramic]

thanks guys