Welcome to WebmasterWorld Guest from 54.242.134.77

Forum Moderators: open

Message Too Old, No Replies

SQL staement to change field

want to update field from a to b

     

weddingm

5:28 pm on Feb 23, 2010 (gmt 0)

5+ Year Member



I want to have an sql statement to UPDATE tablexyz.

Basically:

Select * FROM tablexyz and update field b from the value in field a and override what already exists in field b.

Thanks,
Matt

Zipper

6:03 pm on Feb 23, 2010 (gmt 0)

10+ Year Member



This really belongs in the Database forum.. but ya, are you trying to copy the value in field a to field b? if so you can just simply run a update query like,

UPDATE tablexyz SET field_b = field_a WHERE <any conditions you want matched>

weddingm

6:24 pm on Feb 23, 2010 (gmt 0)

5+ Year Member



awesome, thanks!
 

Featured Threads

Hot Threads This Week

Hot Threads This Month