SQL queries to delete a row based on a string in it's name code example

Example: mysql delete from where like

DELETE FROM bar where

field1 like '%foo%' 
OR
field2 like '%foo%'
OR
...
fieldLast like '%foo%'