Breaking News: Grepper is joining You.com. Read the official announcement!

whereJsonContains laravel

Add Answer

Lokesh003 answered on August 1, 2020 Popularity 10/10 Helpfulness 5/10

answer whereJsonContains laravel

related laravel whereJsonNOTContains

related WhereJsonContains in laravel

whereJsonContains laravel

Comment

The data types have to match:

// [1, 2]
->whereJsonContains('players', 1)   // Works.
->whereJsonContains('players', '1') // Doesn't work.

// ["1", "2"]
->whereJsonContains('players', '1') // Works.
->whereJsonContains('players', 1)   // Doesn't work.

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Aug 01 2020

Lokesh003

0 Answers Avg Quality 2/10

Closely Related Answers

laravel whereJsonNOTContains

Comment

// JSON related and helpful functions:

->whereJsonContains('json_column_name->key->nested_key', $value)
->whereJsonDoesntContain('json_column_name->key', $value)
->orWhereJsonContain('json_column_name', $value)
->orWhereJsonDoesntContain('json_column_name', $value)
// Variations should be valid for all examples above

// Please note data types need to match -> $value = 1 !== "1", so if you search for "1" as a string, in an array of numbers [1,2] it won't work:
  // [1, 2]
->whereJsonContains('players', 1)   // Works
->whereJsonContains('players', '1') // Doesn't work

// ["1", "2"]
->whereJsonContains('players', '1') // Works
->whereJsonContains('players', 1)   // Doesn't work

Popularity 9/10 Helpfulness 8/10 Language php

Source: github.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Dec 30 2022

PDXfoster

0 Answers Avg Quality 2/10

WhereJsonContains in laravel

Comment

PlanificacionInfo::select('datos_complementarios')->WhereJsonContains('datos_complementarios', ["value" => "Escamonda 2019"]);

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Nov 29 2022

Muhammad Tariq

0 Answers Avg Quality 2/10

whereJsonContains laravel

Contents

More Related Answers

whereJsonContains laravel

Closely Related Answers

laravel whereJsonNOTContains

WhereJsonContains in laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.