MYSQL Json query

Question

I have a JSON array of objects in a MySQL table that I am trying to see if there is a way to query and just pull the data. For example.

JSON Array Object

email_address_dump
[{"value":"[email protected]","type":"personal"},{"value":"[email protected]","type":"personal"},{"value":"[email protected]","type":"personal"}]

is there a way to query out just the email address? so that the results can be something like this?

[email protected], [email protected], [email protected]

I am not trying to search within the column, I know that with JSON Obtains you can use a where clause, this is more of a JSON Extract.

Does this answer your question? How to search JSON data in MySQL? — JohnHC
– JohnHC, Commented Aug 18, 2021 at 9:05
@JohnHC no, I am not trying to search but to extract the data. I think I found the answer by doing JSON Extract. — chewie
– chewie, Commented Aug 18, 2021 at 9:06

chewie · Accepted Answer · 2021-08-18 13:32:47Z

1

I was able to solve this by using JSON Extract from MySQL.

json_extract(c.email_address_dump, ''$[*].value') as EmailAddressArray,

answered Aug 18, 2021 at 13:32

chewie

5695 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL Json query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related