SQL command replace a word in the products description with Variable word?
I want to use SQL command to find and replace a word in the products description, and I want to replace with Variable word, such as replace some word with the exactly product's name, I use this command:
update products_description set products_description=replace(products_description,'xxx','$meta_products_name');
but it did not work at all, it just replace all xxx with $meta_products_name, can not get the product's name and replace xxx, anyone can help me?
By moro in forum Installing on a Windows Server
Last Post: 18 Dec 2011, 03:14 PM
By GMCto in forum Templates, Stylesheets, Page Layout
Last Post: 18 Feb 2010, 04:56 PM
By haredo in forum Basic Configuration
Last Post: 8 Dec 2009, 03:30 AM
By signprint in forum General Questions
Last Post: 15 Mar 2009, 12:34 PM
By seanruk in forum General Questions
Last Post: 29 Jul 2008, 10:43 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC