PostgreSQL解决"Abc_de_fghijkl_mn" 首字母小写去掉下划线并且下划线后面的第一个字母大写或首字母大写去掉下划线并且下划线后面的首字母大写的js...

select "lower"(substr('Abc_de_fghijkl_mn', 1, 1)) || substr(replace(REGEXP_REPLACE(INITCAP('abc_de_fghijkl_mn'), '(\w)[_]', '\1') ,'_',''),2)

select lower(substr('Abc_de_fghijkl_mn', 1, 1)) || substr(replace(initcap(replace('Abc_de_fghijkl_mn', '_',' ')),' ',''),2)
select upper(substr('Abc_de_fghijkl_mn', 1, 1)) || substr(replace(initcap(replace('Abc_de_fghijkl_mn', '_',' ')),' ',''),2)

转载于:https://www.cnblogs.com/BoYu045535/p/5970078.html