mysql数据库版本5.7+
一:需求
select result from dam_common_job_result where job_id = 28;
将json字符串中的batchNumber取出
解决方案
采用mysql内置语法JSON_EXTRACT来解析字符串
select JSON_EXTRACT(result, '$.resultMap."2".batchNumber') as batchNumber from dam_common_job_result where job_id = 28;
虽然得到结果,但是都带有双引号,优化一下吧
select JSON_UNQUOTE(JSON_EXTRACT(result, '$.resultMap."2".batchNumber')) as batchNumber from dam_common_job_result where job_id = 28;
完美解决