Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Copy Value to Other Field

Quote Reply
Copy Value to Other Field
I have another Field in Category called C_Slug.

Any idea using a mysql command to copy the value of Name into C_Slug for each category listing?

(C_Slug field is empty)


Free JavaScripts @ Insight Eye

Last edited by:

Eraser: Jan 16, 2008, 1:03 PM
Quote Reply
Re: [Eraser] Copy Value to Other Field In reply to

Not quite sure what your trying to do :/

If you have 2 fields in the "Category" table, and you want to copy from C_Slug => Testing (for example), you could use:

UPDATE glinks_Category SET C_Slug = Test;

(be sure to backup first though, in case it doesn't do what you want =))

Hope that helps.


Andy (mod)
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Last edited by:

Andy: Jan 17, 2008, 12:25 PM
Quote Reply
Re: [Eraser] Copy Value to Other Field In reply to
UPDATE glinks_Category SET Name = C_Slug

Last edited by:

Wychwood: Jan 17, 2008, 11:36 AM