Json 查询

https://blog.51cto.com/u_12897/11547277

https://blog.csdn.net/frostlulu/article/details/135767757

http://www.codebaoku.com/it-mysql/it-mysql-237831.html

错误排除：
https://www.jianshu.com/p/6c8639eb52b0

示例

 SELECT a.* FROM (
 SELECT id, report_name, report_code,
 (case when enable = 1 then '启用' ELSE '禁用' END  ) qiyong ,
  (case when delete = 0 then '' ELSE '已删除' END  ) shanchu ,
(CASE WHEN JSON_VALID(table_column) THEN JSON_search(table_column,'all','/cityFirst/analysisdaily')  ELSE null END) AS contain 
 FROM gaea_table ) a WHERE a.contain IS NOT null

gaea_table 表名字
table_column json表字段名字
/cityFirst/analysisdaily 查询的值 可以like 通配符