<p>我想从数据库中获取那些不等于"My Msg"的记录。</p> <p>我的数据库列中的JSON如下：</p> <pre class="brush:php;toolbar:false;">`{ "msg": "My Msg", "resource_id": "Resourse" }`</pre> <p>我尝试了<code>JSON_EXTRACT</code>和<code>whereJsonContains</code></p> <p>但是没有运气，我使用的是Laravel 8与MySQL。</p> <p>查询如下：</p> <pre class="lang-php prettyprint-override"><code>$records = DB::table('atble')->select('res_id', 'msg_string')->where('res_id', $param)->whereJsonContains('ret_string->msg', ['elem1','elem2'...])->latest()->first(); </code></pre> <p>上述查询没有给我任何结果。</p> <p>任何帮助将不胜感激。</p>

$records = DB::table('atble')->select('res_id',
'msg_string')->where('res_id',
$param)->whereJsonContains('ret_string->msg', ['object_key' => 'object_value'])->latest()->first();

$array = [0 => 1, 1 => 2, 2 => 3];

// Eloquent
PaymentTransaction::whereJsonContains('payload->ProductCode- >id',$array)->get();