mysql 如果版本低无法使用json格式化查询数据【解决方案】

最新推荐文章于 2023-05-19 16:29:59 发布

MiMing仔

最新推荐文章于 2023-05-19 16:29:59 发布

阅读量744

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/QQ563627436/article/details/127249502

版权

示例：
${query.db.cif}.de_aes(ifnull(optu.user_name, case
when cpi.opt_id = ‘multiplyOperator’ then REPLACE
(
SUBSTRING(
REPLACE(cpi.extend_params, ‘}’, ‘,’),
LOCATE(‘optName":’, REPLACE(cpi.extend_params, ‘}’, ‘,’)) +
CHAR_LENGTH(‘optName":’),
LOCATE(
‘,’,
REPLACE(cpi.extend_params, ‘}’, ‘,’),
LOCATE(‘optName":’, REPLACE(cpi.extend_params, ‘}’, ‘,’)) +
CHAR_LENGTH(‘optName":’)
) -
(LOCATE(‘optName":’, REPLACE(cpi.extend_params, ‘}’, ‘,’)) +
CHAR_LENGTH(‘optName":’))
), ‘"’, ‘’)
when optu.user_name is null then ‘’
end)) as opt_name,
cpi.buss_group_code as buss_group_code,
case
when cpi.extend_params REGEXP ‘buyer"\ *: *“[^”]+"’ and cpi.extend_params REGEXP ‘seller"\ *: *“[^”]+"’ then ‘全部支持’
when cpi.extend_params REGEXP ‘buyer"\ *: *“[^”]+"’ then ‘买方付息’
when cpi.extend_params REGEXP ‘seller"\ *: *“[^”]+"’ then ‘卖方付息’
else ‘’
end as pay_acc_type,