MySQL JSON: select json data field in 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 |
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 |
