How to determine if JSON value and parameter are not equal in Laravel?

Question

I want to get those records from the database that are not equal to "My Msg".

The JSON in my database column is as follows:

`{
   "msg": "My Msg",
   "resource_id": "Resourse"
 }`

I tried JSON_EXTRACT and whereJsonContains

But no luck, I'm using Laravel 8 with MySQL.

The query is as follows:

<code>$records = DB::table('atble')->select('res_id',
'msg_string')->where('res_id',
$param)->whereJsonContains('ret_string->msg',
['elem1','elem2'...])->latest()->first();
</code>

The above query gave me no results.

Any help would be greatly appreciated.

Answer 1

You must try this

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

Also follow the correct guidelines for WhereJsonContains

You can also refer to this linkfor more help

Here is an example, it will help you.

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

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