[SOLVED] How to search and replace text in a product description using PHP My Admin?

[Shaun]

I've looked on the web and the forum on how to do this, but I'm hesitant to run a SQL command as it is my first time trying this and I can't find clear cut instructions (or don't understand).
Basically I want to replace certain text in my product descriptions but despite searching through the SQL tables, I can't seem to find what table contains this information. I thought it would be 'product', but i don't see the description text anywhere.

Can someone who has done this before advise on how to do this? Thanks...

Solved: I found the table, it was "ps_product_lang" with the "description" and "description_short" fields and ran this command under the SQL tab

UPDATE `ps_product_lang` SET `description` = replace(`description`,"Pink/Rose","Pink");

[mesotek]

Hi, 

 

I found 1 more easy way to find & replace any text / URL / Hyperlink in Description or in  Short Description, 

 

I have kept 1 Calculator link in all products pages under short description, so i need to change the URL so i used this attached PHP file,

I have used this file more than 100 times in wordpress but in Prestashop i have used 1st time & its worked well !!!

Still you are advised to take backup of your Database because there is no UNDO,

Steps:

 

 

 

1) Download Attached searchreplacedb2.zip PHP file (searchreplacedb2.php), 

2) Paste it in your Root directory

3) open it in browser like: http://localhost/yourproject/searchreplacedb2.php

4) Fill the Database Details , (See what i filledup, I used In : Server Name: Localhost , Database name: mydb, Username: root , Password: (leave this empty) & click on Submit DB details

5) Now you can keep the text which you want to find & replace ,

 

for eaxmple keep in find field: http://localhost/aesteironsteelpipes/content/4-steel-pipe-manufacturer.html

& in replace keep below:

 http://localhost/aesteironsteelpipes/content/4-ASTM-A106-gradeB-steel-pipes-steel-tubes-supplier.html

 

Please note: If you have uploaded website on any domain name then also you can easily use it with same steps but also fill Database Password (i mentioned in Point No. 4)

 

Online example to Find & replace:

1) Same as above

2) Same as above

3) Same as above

4) Same as above  but also fill Database Password

5) Example to find & replace:

 

i wanted to change this URL i manually used in my all products description:

 

so keep in find field:

http://www.aesteironsteelpipes.com/about-us-4.html

 

& keep in replace field:

http://www.aesteironsteelpipes.com/astm-a106-sa106-pipe/9-seamlesspipes-type-astm-a106-grb-pipe-carbonsteel-pipe.html

Edited December 10, 2015 by mesotek (see edit history)