Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: SQL command to find and replace a word in the products description

    The problem is because you are replacing something containing quotes and you are using the same quotes in your replace ...

    Try using:
    UPDATE zen_products_description SET products_description = REPLACE("2x3'", "2x3 Foot");
    Note: you could run this command as:
    UPDATE products_description SET products_description = REPLACE("2x3'", "2x3 Foot");
    from the Tools ... Install SQL Patches ... and it will adjust for the database table prefix ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  2. #12
    Join Date
    Oct 2008
    Posts
    6
    Plugin Contributions
    0

    Default Re: SQL command to find and replace a word in the products description?

    Awesome Thanks. I will try that today and see how it goes for me. Thanks for getting back so quickly.

    -Harrison

  3. #13
    Join Date
    Oct 2008
    Posts
    6
    Plugin Contributions
    0

    Default Re: SQL command to find and replace a word in the products description?

    So I tried both of them and I got the following error. Failed: 1
    Error ERROR: Cannot execute because table zen_products_description does not exist. CHECK PREFIXES! with this note: Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

  4. #14
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: SQL command to find and replace a word in the products description?

    Silly silly me ... slight error on the replace statement:
    Code:
    UPDATE products_description SET products_description = REPLACE(products_description, "2x3'", "2x3 Foot");
    The REPLACE needs the field in it as well ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v139h SQL find and replace
    By gloerick in forum General Questions
    Replies: 4
    Last Post: 12 Dec 2022, 09:16 PM
  2. Replies: 3
    Last Post: 11 May 2012, 12:35 PM
  3. Word HEADER_ bin the menu bar and after the word login
    By moro in forum Installing on a Windows Server
    Replies: 1
    Last Post: 18 Dec 2011, 03:14 PM
  4. Adding an attribute to all products using SQL command?
    By arniesbarmyarmy in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 20 Oct 2009, 03:47 AM
  5. SQL Patch command / query for changing description.
    By signprint in forum General Questions
    Replies: 3
    Last Post: 15 Mar 2009, 12:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR