delete all from table where ID is searched
delete from TABLE_NAME where SOME_ID in (select OTHER_ID from OTHER_TABLE where NAME like '%MY NAME%');