how to replace last 5 digits with 99999 in update query, guide me how to do it : i have one column ,in that column all rows are having 10 digits '1234567890'
By using update postgresql update sql i need to update last 5 digits to 99999. ie '1234599999'

Can any one provide me update query for above requirement