tags:

views:

32

answers:

2
DELETE FROM mytable WHERE column1.find("has_this_word_somewhere") ?
+2  A: 

You use LIKE

DELETE FROM table where column LIKE '%SOMETHING%';

Laykes
Don't use double quotes to delimit SQL string literals. They are an invention of the devil.
Roland Bouman
+1  A: 

isn't this just the same as where column like '%has_this_word_somewhere%'

phatmanace