Remove string from field using MySQL

Question

I want to remove the string;

<p><span style="color: #008000;">-- Instant Download --</span></p>

from a the field description_short in the table ps_product_lang I have tried the following SQL query

update ps_product_lang set description_short = replace(description_short, ‘<p><span style="color: #008000;">-- Instant Download --</span></p>’, ‘’);

But I get the error message

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>-- Instant Download --

â€™, â€˜â€™)' at line 1"

I believe its the quotes and --< that may be the issue, does anyone know how to make the query work> Thanks

Gordon Linoff · Accepted Answer · 2014-09-11 13:14:13Z

2

This is your code:

update ps_product_lang
    set description_short = replace(description_short, ‘<p><span style="color: #008000;">-- Instant Download --</span></p>’, ‘’);

The only problem that is obvious to me are the curly single quotes. Try replacing them with regular single quotes:

update ps_product_lang
    set description_short = replace(description_short, '<p><span style="color: #008000;">-- Instant Download --</span></p>', '');

answered Sep 11, 2014 at 13:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

Adrián Moreno D · Accepted Answer · 2014-09-11 13:14:58Z

0

why not to do the replace by PHP and after update the full field in mysql? Maybe is not the most correct way, but it works and is easy and fast to code that solution.

answered Sep 11, 2014 at 13:14

Adrián Moreno D

11 bronze badge

Collectives™ on Stack Overflow

Remove string from field using MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related