REGEXP($$$,"/^[+]{0,1}(\d+)$|^[+]{0,1}(\d+\.\d+)$/")这个一直提示非法。我想要判断不是数字(包含小数)的值
在数据库将数据转换了在在显示在报表里面的
select case when story_point REGEXP '[^0-9.]' then '0.5'
when story_point is null then '0.5'
else story_point end as story_point
from 表
转义字符要转两次
REGEXP($$$,"^/[+]{0,1}(\\d+)$|^[+]{0,1}(\\d+\\.\\d+)$/")
1min目标场景问卷
立即参与
