如何在mysql json数组中编写SELECT查询

Question

I am trying to get the email from the array json, but it returns null value

[
    {
        "name": "Arun", 
        "email": "[e-mail]"
    }, 
    {
        "name": "Arun kumar",
        "email": "[e-mail]"
    }
]

and my Json query is select json->>"$.name" as email from json

But this query is return null value

Answer 1

I tested the following and worked for me on your json sample

$json='[{"name": "Arun", "email": "[e-mail]"}, {"name": "Arun kumar", "email": "[e-mail]"}]';
$data=json_decode($json,true);

foreach ($data as $key => $value) {
    echo $value["email"] . "<br>";
}