MySQL JSON: select json data field in SQL

HEAD

revision 1745e7060227299cf68f7dae675af5699c004a65

raw

query.sql

1

SELECT general->"$.country" AS country FROM node_data HAVING country IS NOT NULL

History

phorkie, the self-hosted, git-based pastebin software is available under the AGPL.