How to check value in JSON?

Question

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

Answer 1

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