Can I use the SQL Query to extract the json values?

• norsizu

• September 18, 2021 at 1:36 am

ACF is a great WP plugin, thanks.
I’m using Metabase to generate data reports, but some of the fields stored using json look like this

a:2:{i:0;s:12: "Test 1";i:1;s:12: "Test 2";}

Is there a way to extract the json values directly into the results in SQL Query, thanks a lot.

• John Huebner

• September 24, 2021 at 12:14 pm

That is not a JSON value, that is a serialized array.

https://www.php.net/manual/en/function.serialize.php

https://www.php.net/manual/en/function.unserialize.php