DELETE FROM mytable WHERE column1.find("has_this_word_somewhere") ?

You utilize LIKE

Remove FROM table where column LIKE '%SOMETHING%'

is not this likewise as where column like '%has_this_word_somewhere%'