...

View Full Version : copy field content to another field in same table



needsomehelp
01-05-2012, 03:26 PM
How do I copy content from one field to another when both field are in the same table?

Old Pedant
01-05-2012, 08:17 PM
UPDATE tablename SET tofield = fromfield

If you only want that to happen for *some* values, then just add a WHERE clause:


UPDATE tablename SET tofield = fromfield WHERE somecondition



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum