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,} 比较

        SELECT
            IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[0]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name,
                IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[1]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name,
                    IF(JSON_EXTRACT( JSON_EXTRACT( a.operate_detail_json, '$[0].stockProfitPredictList[2]' ), '$.predictedIncome' ) REGEXP '[0-9]{1,}',b.short_name,NULL))) AS stockShortName
        FROM
            stock_predict_log a