sql - lower first letter of column by keeping rest as it is

Question

My data is like

users table:

ID       Name          Address
1        Shane         England
2        Mark          NewZeaLand
3        Andrew        Jordon

I want to update address in users table like newZeaLand.

here is what i have tried
but it is lowering all letters as lower case

update users  
set Address=lower(Address)  
where ID=2

标签： sqlpostgresql

Answer 1

这是你想要的吗？

update users  
    set Address = lower(substr(address, 1, 1)) || substr(address, 2)
    where ID = 2;