MySQL SQL Query to Delete a String From Records

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?

Please look here: http://stackoverflow.com/questions/4271186/how-can-i-use-mysql-replace-to-replace-strings-in-multiple-records — Hockenberry, Feb 04 '15 at 14:16

score 0 · Accepted Answer · answered Feb 04 '15 at 14:15

0

Use the REPLACE() function.

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

answered Feb 04 '15 at 14:15

neuhaus

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. – jarlh Feb 04 '15 at 14:19

score -1 · Answer 2 · answered Feb 04 '15 at 14:15

-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 04 '15 at 14:15

Rob

1

I think you have the orders of the parameters wrong. – neuhaus Feb 04 '15 at 14:16
it is highly likely that I do. that's why I would use the google first before actually doing it. ;) – Rob Feb 04 '15 at 14:26

2 Answers2