CODEWITHSUNDEEP
mysqlsqljsonjson-extract
Mateusz Chmielnicki
Mateusz Chmielnicki

Reputation: 1

How to check value in JSON?

I need to check if the value is in this JSON field

SELECT * FROM my_table WHERE JSON_EXTRACT(my_column, '$[*]') = 1

OR

SELECT * FROM my_table WHERE 1 IN (JSON_EXTRACT(my_column, '$[*]'))

My field: [1,2,3,4]

RESOLUTION WORK:

SELECT * FROM my_table WHERE JSON_SEARCH(my_column, "one", "1") IS NOT NULL

Upvotes: -1

Views: 58

Answers (1)

Mateusz Chmielnicki
Mateusz Chmielnicki

Reputation: 1

SELECT * FROM my_table WHERE JSON_SEARCH(my_column, "one", "1") IS NOT NULL

Upvotes: 0

Related Questions