Forum Moderators: open
Table Name: People
Fields: id, name, official_name, etc
It's populated like:
1,frank,null
2,jo,null
3,sam,null
etc...
How would I update all official_name fields with the name fields?
So the table would become:
1,frank,frank
2,jo,jo
3,sam,sam
Is there an update that can do this in MySQL?