MySQL JSON: select json data field in SQL
sql
1 2 3 4 5 | SELECT general->"$.country" AS country FROM node_data HAVING country IS NOT NULL -- remove quotes from string data SELECT general->>"$.country" AS country FROM node_data |
sql
1 2 3 4 5 | SELECT general->"$.country" AS country FROM node_data HAVING country IS NOT NULL -- remove quotes from string data SELECT general->>"$.country" AS country FROM node_data |
