I have a large database having imported the open directory local section, But I need to edit it, and I can't edit 141,000 categories individually. Is it possible to write a code that will write information to my database so that I can do if/then things like
if
category = USA (or any categories below eg New York)
then
set the field "banner_486"
to
"bannercode_usa_486"
Also
if
category = USA (or any categories below eg New York)
append the contents of the field "meta_keywords"
with
"usa,united states,america"
Also
if
category includes the word "Business"
then
set the field related categories
to
"business_and_shopping"
An answer to whether this is possible would be a great start, pointing me in the direction of how to do it would be even better.
if
category = USA (or any categories below eg New York)
then
set the field "banner_486"
to
"bannercode_usa_486"
Also
if
category = USA (or any categories below eg New York)
append the contents of the field "meta_keywords"
with
"usa,united states,america"
Also
if
category includes the word "Business"
then
set the field related categories
to
"business_and_shopping"
An answer to whether this is possible would be a great start, pointing me in the direction of how to do it would be even better.