mysql replace parts of a string

Question

I'm trying to do this in mysql . How can I replace parts of a string in a column in MYSQL with 1000 records. Change all records form .JPG to .gif

eg. DC3444.JPG to DC3444.gif

juergen d · Accepted Answer · 2012-06-02 16:18:09Z

7

update your_table 
set some_column = replace(some_column, '.JPG', '.gif')

answered Jun 2, 2012 at 16:18

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Comment

thanks man, worked. what about appending 0 to the start of a string of phone numbers in the records. eg. 222,334 to 0222,334

rkosegi · Accepted Answer · 2012-06-02 16:18:27Z

3

UPDATE table1 SET col1 = REPLACE(col1, '.JPG','.gif')

answered Jun 2, 2012 at 16:18

rkosegi

14.8k5 gold badges57 silver badges90 bronze badges