editing all product descriptions thru sql

[Guest]

Hello,

 

Is there a way i can use sql commands, to edit all product descriptions so that i can remove

<P><STRONG><FONT size=3>.....</FONT></STRONG></P>

 

and just leave the ... (the description itself)

 

 

 

 

thanks

[♥bruyndoncx]

yes, mysql has the necessary function:

 

REPLACE(str,from_str,to_str)

Returns the string str with all occurrences of the string from_str replaced by the string to_str. mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');

-> 'WwWwWw.mysql.com'

 

This function is multi-byte safe.

 

so your sql becomes:

UPDATE Products_Description

SET products_description = REPLACE(products_description, '<p><strong><font size=3>','')

 

for the first html sequence to replace, similar construct for the second one.

[Guest]

that is a nice trick. But its almost the same thing as if i was editing it through admin. All my products (which have different product names) have the product name being repeated in the description.

 

 

Can't i perform a sub-query that matches any product name in the product description and then calles the replace function.

 

thanks

[♥bruyndoncx]

UPDATE Products_Description

SET products_description = REPLACE(products_description, products_name,'')

 

This will replace the products_name in the description field, if it doesn't find it, it will just update the description with itself

[Guest]

thanks.