CODE EXAMPLE FOR SQL

mysql delete entire row on condition

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;