deleting records where like mysql code example

Example 1: mysql delete entire row on condition

DELETE FROM table_name [WHERE Clause]

Example 2: mysql delete from where like

DELETE FROM bar where

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