delete data ending in ...

it is possible to delete some data ending in "tr" (for exemple)

 

In MySQL should be:

DELETE FROM TableName WHERE COLUMN_NAME LIKE '%tr';

Code (markup):

Regards

 

agree with koko5

DELETE FROM TABLE WHERE YOUR_COLUMN LIKE '%tr';

 

thanks .... you save a lot of time

 

and ... another thing ... i have a e-mail adress list and i want to keep only the yahoo hotmail gmail aol users ... is any command to delete the rest?

 

Something like this

DELETE FROM TableName WHERE COLUMN_NAME NOT REGEXP '[[.commercial-at.]](yahoo|gmail|googlemail|aol|hotmail)';

Code (markup):

 

here are some examples
DELETE FROM example WHERE age='15%'