Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

Pages: 1

 

#1 03-05-2014 02:01:28

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Mass Product Description Find and Replace

Is there a way to perform a mass find and replace of text in the long product description field?

Last edited by sdn (03-05-2014 02:04:11)

Simon

Offline

 

#2 03-05-2014 12:58:44

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Mass Product Description Find and Replace

Sure.  MySQL makes it easy:

UPDATE ecom_prod SET desclong=REPLACE(desclong,'Find','Replace')

Nick Hendler

Offline

 

#3 03-06-2014 05:54:11

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Mass Product Description Find and Replace

Cool! Need to be pretty careful with this function though...

Simon

Offline

 

#4 03-06-2014 10:12:53

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Mass Product Description Find and Replace

True, so true.

Nick Hendler

Offline

 

#5 03-13-2017 03:42:16

StJosephRoy
Member
Registered: 08-08-2016
Posts: 9

Re: Mass Product Description Find and Replace

And, must double quotation marks in the 'Replace' string be escaped out?

Thanks,

Roy Doucette

Offline

 

#6 03-13-2017 18:11:41

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Mass Product Description Find and Replace

Only single quotes (which are the encapsulation character) need to be escaped.

Nick Hendler

Offline

 

 

Pages: 1

Board footer