delete particular string from table in mysql code example

Example 1: mysql delete entire row on condition

DELETE FROM table_name [WHERE Clause]

Example 2: mysql delete rows

DELETE FROM table_name
WHERE condition;