Editing content contained in a field

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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
SELECT * FROM `events` WHERE `EVT_name` LIKE '%Jazz Stage: %';

How do I edit the fields using a simple query?

Thanks for the help.

Site Timeline