Nikhil Sharma

Latest News

  1. Home
  2. Blog
Json Array object search key value Mysql

Json Array object search key value Mysql

How to search JSON array in MySQL?

How to search JSON array in MySQL?

Get json array key value query - 

SELECT  1 AS id, '[{"name": "aman"}, {"name": "jay"}]' AS arr

Example to fetch json array object 

SELECT JSON_CONTAINS(arr, '{"name": "jay"}') from test WHERE id=1;

JSON_CONTAINS(arr, '{"name": "jay"}')
1

Syntax

The syntax goes like this:

JSON_CONTAINS(target, candidate[, path])
JSON_CONTAINS will return output in 1 or 0 

Author: Nikhil Sharma

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis.

1 Comments

  1. Nikhilsays Dec 07

    [email protected]
    9529921038

    nikhil sharma


Leave a reply