MySQL SQL Query to Delete a String From Records [duplicate]

Question

I need a MySQL Statement to delete the following string from the text in the field called post_content

E.g. String: [css3_grid id='gcse'], How can I do it?

neuhaus · Accepted Answer · 2015-02-04 14:15:39Z

0

Use the REPLACE() function.

UPDATE table SET post_content = REPLACE(post_content, 'String: [css3_grid id=''gcse'']', '');

answered Feb 4, 2015 at 14:15

neuhaus

4,1741 gold badge13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If it's a huge table it can be nice to also have WHERE post_content like '%String: [css3_grid id=''gcse'']%', to make transaction smother.

Rob · Accepted Answer · 2015-02-04 14:15:10Z

-1

You're going to want to do something like this:

UPDATE table SET post_content = REPLACE( '[css3_grid id=\'gcse\']' , '' , post_content )

answered Feb 4, 2015 at 14:15

Rob

592 bronze badges

I think you have the orders of the parameters wrong.

it is highly likely that I do. that's why I would use the google first before actually doing it. ;)