我试图从数组json获取电子邮件,但它返回空值
[ { "name": "Arun", "email": "arun@arun.com" }, { "name": "Arun kumar", "email": "arunkumar@gmail.com" } ]
我的json查询是 select json->>"$.name" as email from json
select json->>"$.name" as email from json
但此查询返回空值
这应该管用,
JSON_EXTRACT(yourstring, '$[*].email')
yourString—数据库中的json数据或字段 $ 是搜索json对象的json语法 * 表示所有多维数组 email 检查电子邮件输入*值
$
*
email
我测试了以下内容,并为我编写了json示例
$json='[{"name": "Arun", "email": "arun@arun.com"}, {"name": "Arun kumar", "email": "arunkumar@gmail.com"}]'; $data=json_decode($json,true); foreach ($data as $key => $value) { echo $value["email"] . "<br>"; }
