remove rows that do not contain

TVining

New Member

Join Date: Dec 2007

Posts: 26
#1

remove rows that do not contain

Jan 21 '08, 03:11 PM

I want to remove all rows that do not contain the word "FRENCHFRY" in them.
I have tried a few things, with varied results, but nothing consistent.

Tony
Tags: None
mwasif

Recognized Expert Contributor

Join Date: Jul 2006

Posts: 802
#2

Jan 21 '08, 04:01 PM

You can write your query as
[CODE=mysql]DELETE FROM table_name WHERE column1 NOT LIKE '%FRENCHFRY%'[/CODE]
Comment

Comment