MySQL：搜索 JSON 数据时不区分大小写

[wanghao]

SELECT
  originalname,
  metadata,
  JSON_EXTRACT(file.metadata, "$.Make") as make
FROM
  file
WHERE
  JSON_EXTRACT(file.metadata, "$.Make", '$.Model') 
  LIKE '%5d%' COLLATE utf8mb4_general_ci

加上 collate 就可以了。