UPDATE db_name SET filename = REPLACE(filename, ’_JPG’, ’.JPG’) WHERE 1; Post navigation Delete duplicate db records changing field char set to store Emoji Character in MySQL
