MySQL JSON查询

Published on 2022-10-20 in Posts

Updated on 2023-12-15

⚠️ This entry is already over one year old. It may no longer be up to date. Opinions may have changed.

查询json_array包含指定内容

$a1 = [];
 $q2 = "";
 foreach ($qualificate as $v) {
     array_push($a1, intval($v));
     $q2.="'".intval($v)."',";
 }

 $q1 = implode(',', $a1);
 $q2 = rtrim($q2,',');
 $res = Db::query("SELECT id, JSON_CONTAINS(qualificate,JSON_ARRAY({$q1}),'$') as q1, JSON_CONTAINS(qualificate,JSON_ARRAY({$q2}),'$') as q2 FROM `info_job_wanted` HAVING q1=1 or q2=1");

查询json_object的某个key等于指定value

select * from table where json->'$.id'=1;