mysql find replace update mysql table field michael May 10, 2019 UPDATE db_name SET filename = REPLACE(filename, ’_JPG’, ’.JPG’) WHERE 1;
michael