MySQL replace part of string

Question

I have a varchar field with latitude values.
I would like to replace part of the string, the "integer" part,

for example:

should change to:

Thanks in advance for your help.

M Khalid Junaid · Accepted Answer · 2014-03-28 15:24:47Z

4

If 20 is a hardcoded string you want to replace with values before point you can do so

UPDATE table 
SET latitude = CONCAT('20.',SUBSTRING_INDEX(latitude ,'.',-1))

Fiddle Demo

answered Mar 28, 2014 at 15:19

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.