View Full Version : copy field content to another field in same table
01-05-2012, 04:26 PM
How do I copy content from one field to another when both field are in the same table?
01-05-2012, 09: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
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.