Gossamer Forum
Home : Products : Gossamer Links : Discussions :

writing to fields in sql

Quote Reply
writing to fields in sql
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.
Subject Author Views Date
Thread writing to fields in sql cities 1957 Sep 6, 2001, 2:23 PM
Post Re: writing to fields in sql
Alex 1895 Sep 6, 2001, 2:29 PM