Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Copy Value to Other Field

Jan 16, 2008, 1:02 PM
Eraser
Enthusiast (619 posts)
Jan 16, 2008, 1:02 PM
Post #1 of 3
Views: 403
Shortcut
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)

~ ERASER

Free JavaScripts @ Insight Eye

Last edited by:

Eraser: Jan 16, 2008, 1:03 PM
Jan 17, 2008, 3:06 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Jan 17, 2008, 3:06 AM
Post #2 of 3
Views: 381
Shortcut
Quote Reply
Re: [Eraser] Copy Value to Other Field In reply to
Hi,

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:

Code:
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.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Last edited by:

Andy: Jan 17, 2008, 12:25 PM
Jan 17, 2008, 11:35 AM
Wychwood
User (182 posts)
Jan 17, 2008, 11:35 AM
Post #3 of 3
Views: 375
Shortcut
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