Zen Cart Logo
Forums / General Questions / How to Clear categories_description?

How to Clear categories_description?

Locked

Views: 695

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
5 Oct 2009, 3:12 AM
#1
toussi avatar

toussi

New Zenner

Join Date:
Aug 2008
Posts:
45
Plugin Contributions:
0

How to Clear categories_description?

I need the SQL line so I can clear

categories_description inside table: zen_categories_description

I am just trying to clear the field: categories_description and don't want to delete anything else in there.

5 Oct 2009, 3:46 AM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,803
Plugin Contributions:
15

Re: How to Clear categories_description?

There are far better ways to remove a description without doing it this way.
Give us a little better description, the information requested in the posting tips, a URL, and we can give a better answer.

5 Oct 2009, 4:55 AM
#3
toussi avatar

toussi

New Zenner

Join Date:
Aug 2008
Posts:
45
Plugin Contributions:
0

Re: How to Clear categories_description?

I need to clear all my category description writing, because I duplicated the site and am tayloring it for another website, so I cannot have duplicate writing in the categories.

5 Oct 2009, 5:01 AM
#4
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,803
Plugin Contributions:
15

Re: How to Clear categories_description?

Without knowing the number of categories, why would you not just click on the category's edit button in the admin and change the description?

Catalog >> Categories/Products >> green button with e in it.

5 Oct 2009, 7:53 AM
#5
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: How to Clear categories_description?

You are going to have to manually enter each new category description, so for an "ordinary" site deleting the old one at the same time would be trivial. So would the right SQL statement.

5 Oct 2009, 4:04 PM
#6
toussi avatar

toussi

New Zenner

Join Date:
Aug 2008
Posts:
45
Plugin Contributions:
0

Re: How to Clear categories_description?

But, Guys, I WANT TO DELETE ALL THE CATEGORY CONTENTS WITH AN SQL STATEMENT:

Something like

TRUNCATE TABLE "that field of zen_categories_description"

BUt I don't know the right syntax