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
