MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE files (id SERIAL, files_name VARCHAR(128), files_name_copy VARCHAR(128), type INT)
INSERT INTO files (type, files_name)
VALUES
(5, 'The Simpsons - S20E19 - Waverly Hills 9-0-2-1-D''oh -1080p 1,4 Mbps'),
(5, 'The Fresh Prince of Bel-Air - S01E03 - Clubba Hubba WEB-DL-480p 2,0 Mbps -PiA'),
(5, 'Animal Kingdom (2016) - S02E13 - Betrayal WEB-DL-720p 2,1 Mbps'),
(5, 'The Flash (2014) - S04E12 - Honey, I Shrunk Team Flash'),
(5, '13 Reasons Why - S02E01 - The First Polaroid -720p 2,5 Mbps')
UPDATE files 
SET files_name_copy = files_name
UPDATE files 
SET files_name =
    REGEXP_REPLACE(
       files_name,
       '(S[0-9]?[0-9]?[0-9]E[0-9]?[0-9])([^0-9].*)',
       '\\1'
    ) 
WHERE type = 5;
SELECT *
FROM files


id
files_name
files_name_copy
type


1
The Simpsons - S20E19
The Simpsons - S20E19 - Waverly Hills 9-0-2-1-D'oh -1080p 1,4 Mbps
5

2
The Fresh Prince of Bel-Air - S01E03
The Fresh Prince of Bel-Air - S01E03 - Clubba Hubba WEB-DL-480p 2,0 Mbps -PiA
5

3
Animal Kingdom (2016) - S02E13
Animal Kingdom (2016) - S02E13 - Betrayal WEB-DL-720p 2,1 Mbps
5

4
The Flash (2014) - S04E12
The Flash (2014) - S04E12 - Honey, I Shrunk Team Flash
5

5
13 Reasons Why - S02E01
13 Reasons Why - S02E01 - The First Polaroid -720p 2,5 Mbps
5

id	files_name	files_name_copy	type
1	The Simpsons - S20E19	The Simpsons - S20E19 - Waverly Hills 9-0-2-1-D'oh -1080p 1,4 Mbps	5
2	The Fresh Prince of Bel-Air - S01E03	The Fresh Prince of Bel-Air - S01E03 - Clubba Hubba WEB-DL-480p 2,0 Mbps -PiA	5
3	Animal Kingdom (2016) - S02E13	Animal Kingdom (2016) - S02E13 - Betrayal WEB-DL-720p 2,1 Mbps	5
4	The Flash (2014) - S04E12	The Flash (2014) - S04E12 - Honey, I Shrunk Team Flash	5
5	13 Reasons Why - S02E01	13 Reasons Why - S02E01 - The First Polaroid -720p 2,5 Mbps	5