MYSQL batch changes to content in the same column

Problem Recurrence:

In the MYSQL database, the contents of a given column contain ". wmv" and need to change the WMV format after "." To "FLV"

How to Solve

Update  video_info   set  file_path=substring (File_path,1,length (File_path)-3);

Run the above SQL first to delete;

Update  video_info Set file_path = concat (file_path, ' flv ');

Run this statement again to add the FLV to the back.

MYSQL batch changes to content in the same column