[Solved] SQL command - Please help

[probashi]

Hi all,

I have imported product short and long descriptions from a CSV file. However within the descriptions, where there are commas (,) this has been replaced by ,

So for example a sentence will read:
A good product, although cheap.

When it should read:
A good product, although cheap.

As there are hundreds of product descriptions effected, it will be a pain to manually fix this.

Can some body help me with a SQL command that will replace the , with a comma (,)

Thank you in advance

[tomerg3]

make sure yo have a backup of the table just in case.

UPDATE ps_cms_lang SET content = replace(content , ',',',');

[probashi]

Thank you for your reply. I'm getting the below error:


SQL query:

UPDATE ps_cms_lang SET content = replace( content, ‘ & comma;

MySQL said: Documentation
#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 '' at line 1

[tomerg3]

I updated the code, it was replacing ' with a different quote

[probashi]

Thank you

It's still not working - although the SQL is not giving any errors - no rows was updated:

0 row(s) affected. ( Query took 0.0005 sec )

[probashi]

Okay is where the problem may be - just to verify with you

Should it not be ps_product_lang instead of ps_cms_lang?

[tomerg3]

When to see what is the actual string for the , in the content field, it may not be ,, the query is correct, I just checked it.

[probashi]

Sorry, i'm a little bit slow when it come to SQL - i don't really understand what you mean.

Should we not aim the SQL at the ps_product_lang table as this is where the description is for the products within the description field.

Sorry about this - thank again for your help

[tomerg3]

Yeah, sorry, I had CMS in my mind for some reason.

This should do the trick....

UPDATE ps_product_lang SET description = replace(description , ',',','),  description_short = replace(description_short  , ',',','); 

[probashi]

Thank you very much, that did the trick :-)

[tomerg3]

no problem, please add (solved) to the topic