题解 | #博客地址修复#

写复杂了。。。。嗯。。。。

select device_id,(
    case
      when substr(d.a, 7, 1) = '/' then trim(d.a)
      when substr(d.a, 7, 1) <> '/' then trim(replace(d.a, 'http:/', 'http://'))
    end
  ) blog_url
from(
select device_id,trim(blog_url) a from
  user_submit 
) d