Editing content contained in a field

Editing content contained in a field

am 02.08.2006 18:42:34 von skydiver_morgan

I need some quick help with constructing a MYSQL query to help solve a
small problem that I have.

I havea table in my database where I need to search for text withing a
field and delete it. The text that I need to find is not the only text
in the field, it is in the field with other text.

I am able to single out the records that need updating by using the
statement:
SELECT * FROM `events` WHERE `EVT_name` LIKE '%Jazz Stage: %';

How do I edit the fields using a simple query?

Thanks for the help.