MYSQL: delete all rows containing string "foo" in table "bar"

Question

What's the command to achieve this:
MYSQL: delete all rows containing string "foo" in table "bar"

Answer 1

DELETE FROM bar where  field1 like '%foo%'  OR field2 like '%foo%' OR ... fieldLast like '%foo%' 

Answer 2

You'll need to explicitly list the columns I think, so something along the lines of...

 DELETE FROM bar WHERE col1 LIKE '%foo%' OR col2 LIKE '%foo%'....etc