mysql 列所有值,mysql更改列中的所有值

I want to change all values in the tablecolumn "Quellendatum".

When the row-value is 2005-06-20 then it should be replaced with 2012-06-20.

When the row-value is NULL or empty, then it should be untouched.

Currently i modify this manually by selecting the row:

UPDATE `outgoing2`.`tbl_hochschule`

SET `Quellendatum` = '2012-06-20'

WHERE `tbl_hochschule`.`id` =1;

Is there a way to automate this task?

解决方案

How about:

UPDATE outgoing2.tbl_hochschule

SET Quellendatum = '2012-06-20'

WHERE Quellendatum = '2005-06-20'

AND !isnull( Quellendatum );