Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

The syntax looks right to me, any help would be appreciated!

mysql> select fieldnames from tablename limit 5;
+--------------------------------------------------------+
| fieldnames                                             |
+--------------------------------------------------------+
| {"example-field-1": "val2"}                            |
| {"example-field-2": "val1"}                            |
| {"example-field-1": "val1", "example-field-3": "val1"} |
| {"example-field-2": "val1"}                            |
| {"example-field-2": "val2"}                            |
+--------------------------------------------------------+
mysql> select JSON_EXTRACT(fieldnames, '$.example-field-1') from tablename;
ERROR 3143 (42000): Invalid JSON path expression. The error is around character position 17 in '$.example-field-1'.
MySQL 5.7.10
Can you try this advice from https://dev.mysql.com/doc/refman/5.7/en/json.html
As mentioned previously, path components that name keys must be quoted
if the unquoted key name is not legal in path expressions. Let $ refer
to this value.
select JSON_EXTRACT(fieldnames, '$."example-field-1"') from tablename;
If you have more fields, you must quote each key not the whole path:
select JSON_EXTRACT(fieldnames, '$."field"."example-field-1"') from tablename;
                I really wish the Mysql documents would highlight that more. This answer did spare me from going down a rabbit hole.
– avelis
                May 25, 2017 at 17:18
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.