'Query to insert values in a column, according to the value of another column

I have a table with a empty column, and I want to insert values in this column according to the value of another column, something like that:

INSERT INTO table_name(color)
VALUE('blue')
WHERE number = 1
VALUE('red')
WHERE number = 2
VALUE('green')
WHERE number = 3

I know this query not work, it's just to exemplify what I want :)

mysql sql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source