DM

官方文档

使用JSON_TABLE

select count(0)
from JSON_TABLE('["1","2","3"]', '$[*]'
    COLUMNS (value VARCHAR PATH '$')
     ) where value in ('4')

使用JSON_CONTAINS

SELECT JSON_CONTAINS('["1","2","3"]', '"2"');