Postgres 15

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

select version();

version

PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

create table songs(song_id integer  generated always as identity
                                    primary key
                  ,name    text
                  ); 
                  
insert into songs(name) 
     values ('00Zicky_-_San_Pedro_Danilo_Vigorito_Remix_')
          , ('00Zicky_-_San_Pedro__Danilo_Vigorito_Remix__')
          , ('0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx__')
          , ('0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx_')
          , ('01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__')
          , ('01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__'); 

select * 
  from songs;

CREATE TABLE

INSERT 0 6

song_id
name

1
00Zicky_-_San_Pedro_Danilo_Vigorito_Remix_

2
00Zicky_-_San_Pedro__Danilo_Vigorito_Remix__

3
0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx__

4
0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx_

5
01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__

6
01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__

SELECT 6

delete  
  from songs s2 
 where exists ( select null 
                  from songs s1 
                 where s1.song_id < s2.song_id
                   and replace(replace(s1.name, '_',''),'-','') = 
                       replace(replace(s2.name, '_',''),'-','')
              ); 

DELETE 3

select * 
  from songs

song_id
name

1
00Zicky_-_San_Pedro_Danilo_Vigorito_Remix_

3
0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx__

5
01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__

SELECT 3

song_id	name
1	00Zicky_-_San_Pedro_Danilo_Vigorito_Remix_
2	00Zicky_-_San_Pedro__Danilo_Vigorito_Remix__
3	0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx__
4	0101_-_Try_To_Say__Strictlyjaz_Unit_Future_Rmx_
5	01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__
6	01_-_Digital_Excitation_-_Brothers_Gonna_Work_it_Out__Piano_Mix__