mysql json字段模糊查询

[weixin_42005037]

SELECT
count(*) AS AGGREGATE
FROM
`amazondatacollections`
WHERE
JSON_EXTRACT(paramsJson,'$

• .value'
• ) LIKE "%See top 100%";
  AND (`id` <> 0)