Remove HTML string from MySql

Question

How can I remove or replace a string from a column? eg: I want from my articles to remove the string:

<p>John say's "Hello Mary"</p>

I try with the REPLACE() function in phpmyadmin but I get an error. The query is the below:

select `column_name` REPLACE('<p>John say's "Hello Mary"</p>', '<p>John say's "Hello Mary"</p>', '') where id=1234;

Thank you

Take a moment to read through the editing help in the help center. Formatting on Stack Overflow is different than on other sites. The better your post looks, the easier it is for others to read and understand it. — Dharman
– Dharman ♦, Commented Mar 10, 2022 at 13:30

bin2003 · Accepted Answer · 2022-07-01 02:02:11Z

1

The REPLACE() function is often used to correct data in a table, replacing the old string with the new one.

The following is the syntax:

UPDATE 
    table_name
SET
    column_name = REPLACE(column_name, '<p>John say's "Hello Mary"</p>','')
WHERE
    id=1234;

answered Jul 1, 2022 at 2:02

bin2003

255 bronze badges

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

Comments

Valeriu Ciuca · Accepted Answer · 2022-03-10 13:23:53Z

0

The syntax for REPLACE() is like this:

SELECT REPLACE(column_name ,'something','somewhat') FROM your_table WHERE id = 1234;

Also pay attention to quotes: 'John say's "Hello Mary"' - you must escape the one from

say's

for example

answered Mar 10, 2022 at 13:23

Valeriu Ciuca

2,10413 silver badges14 bronze badges

2 Comments

Dimitris T. Over a year ago

Thanks, I get this error now "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. "

kmoser Over a year ago

@DimitrisT. That sounds like a phpMyAdmin message. It is not an error.

Collectives™ on Stack Overflow

Remove HTML string from MySql

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related