how to change column value on a cetain condition in mysql -

i using mysql database. in table saving files name extension. files extension .flv want change file extension .flv .mp4. there way achive in mysql workbench. thanks

try query

update tablename set colname = replace(colname,'.flv','.mp4');