How to delete rows containing specific text string in a Mysql database

“delete from tablename where columnname like ‘%text to match%’; 

Make sure you know the text is contained in only the rows you want to delete otherwise MySQL may delete other database rows you didn’t want deleted