mysql help deleting a field

[javierjp]

Hi, im a totally newbie with mysql code.

I want to delete a word in many fields.  The table name its smf_googletagged and the field its tag, i want to delete all the fields that contain the word "wordtodelete" (its just a example word)

Example of tag field entries:
google+wordtodelete+68445246+++++++
google+wordtodelete+++++
google+wordtodelete++com++++
google+wordtodelete+68445246+++++++
google+wordtodelete+62788934++com++++++
google+wordtodelete++com++++
google+wordtodelete++com++++

whats the sql code to make that?
thanks in advance.

edit: solved, i finally used DELETE FROM `smf_googletagged` WHERE `tag` LIKE '%wordtodelete%'