"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

First of all, do you want to replace that column's content with spaces or do you want to delete the entire row that contains it?

Does a query that looks for "Is this tape helpful for AA Newcomers?" match this row and ONLY this row? If so then you don't need to search for that entire long string. If not, is there another column that contains a value that would uniquely match this row, and ONLY this row, if it were used as an additional search criterion?

We would need answers to these questions in order to construct the correct query to accomplish your goal. Knowing the column name(s) would be beneficial as well otherwise you will likely get a rather generic solution offered.

Databases don't have 'Find and Replace' functions. I have never seen such a thing in the many versions of phpMyAdmin that I use. I would first use the search function on that table to find out how many rows have this text. If there is only 1, you can manually edit it.

Risks to data security are risks to business continuity. Businesses need to know what these risks look like – and where they can turn for help.
Check our newest E-Book and learn how you can differentiate your data protection business with advanced cloud solutions Acronis delivers

With your above SELECT query, it came back with some 3300 rows affected - but there was no option to update or delete that string.

So I tried DELETE FROM `wp_zt8sq9_posts` WHERE post_content like "Is this tape helpful for AA Newcomers?%";.... And a bunch of posts were not showing up on the site and I did catch one 404'ing. I've since imported the old database and everything is back to normal.

Do not do delete as it removes the entire row, if you run, your need is to run update that modifies a column.
The selects are a must to make sure your search criteria is narrow enough to match one or a few rows with data......

Could you provide an example of what the result of the modification you want to end up with.
Current
Having this is some stuff that I have
Want
Having stuff

They are correct, UPDATE is the function you want. You can use it to replace the text you want to get rid of with something else without DELETE-ing the rows.

John HGeneral TinkererAuthor Commented: 2017-03-26

OOps on Delete :/

Current: I have unwanted text in the body of thousands of posts in wordpress. This text/hmtl is located in the table "wp_zt8sq9_posts", column name "post_content", and the content I want removed begins with: "Is this tape helpful for AA Newcomers?..........(with a bunch text and some html after it)"

What I want is to clear/delete all instances of text/html in that column that begins with ""Is this tape helpful for AA Newcomers?........" so that it is no longer printed on the posts that currently contain that text.