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.
