Copy values from one column to another in the same table

How can I make a copy values from one column to another? I have: Database name: list ------------------- number | test ------------------- 123456 | somedata 123486 | somedata1 232344 | 34 I want to have: Database name: list ---------------- number | test ---------------- 123456 | 123456 123486 | 123486 232344 | 232344 What MySQL query should I have?