Hi all,
Final find this way work for me.
UPDATE products
SET products_model = CONCAT('EK',products_model)
WHERE manufacturers_id = 11
AND products_model NOT LIKE 'EK%'
Results 1 to 7 of 7
Hybrid View
-
27 May 2011, 05:07 AM #1
Inactive
- Join Date
- Jan 2007
- Posts
- 375
- Plugin Contributions
- 3
Re: SQL to replace product id how to?
-
27 May 2011, 05:32 AM #2
Totally Zenned
- Join Date
- Apr 2006
- Location
- Texas
- Posts
- 6,196
- Plugin Contributions
- 0
Re: SQL to replace product id how to?
Ty for posting the solution ....
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 Quote
Similar 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
