Back up your database first..... Very Important...
UPDATE products
SET products_model = 'EK00XXX'
WHERE products_model = '00XXX'
Results 1 to 7 of 7
Threaded View
-
16 May 2011, 04:10 AM #4
Totally Zenned
- Join Date
- Apr 2006
- Location
- Texas
- Posts
- 6,196
- Plugin Contributions
- 0
Re: SQL to replace product id how to?
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting
Reply With QuoteSimilar Threads
-
v139h SQL find and replace
By gloerick in forum General QuestionsReplies: 4Last Post: 12 Dec 2022, 09:16 PM -
v139h SQL command replace a word in the products description with Variable word?
By liyucmh in forum General QuestionsReplies: 3Last Post: 11 May 2012, 12:35 PM -
SQL command to find and replace a word in the products description?
By haredo in forum Basic ConfigurationReplies: 13Last Post: 8 Dec 2009, 03:30 AM -
how to replace the description of product in bulk?
By handbag86 in forum Setting Up Categories, Products, AttributesReplies: 1Last Post: 6 Jul 2009, 05:41 PM -
How to replace category/product name with image?
By Rotkale in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 19 Dec 2006, 03:59 PM
