mysql,json_insert函数用法 向json字段插入键值
查询数据库json类型
select JSON_EXTRACT( operate_detail_json, '$[0].adjustContent' )
添加数据库json类型
update tab_json set data = json_insert(data,"$.name","小明") where id = 1;
REGEXP '[0-9]{1,} 比较
1 SELECT 2 IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[0]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name, 3 IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[1]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name, 4 IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[2]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name,NULL))) AS stockShortName 5 FROM 6 stock_predict_log a