Overwrite colomns with other data..

[Anon]

I have a colomn in my table that has 0000 in it. It was supposed to be the year.

My question is, how can i query the table to find end_date that equals 0000 then overwrite it with 2001?

Thanks
Joe

You guys are great..

[gernot]

maybe like that:

UPDATE yourtable SET end_date='2001' WHERE end_date='0000'

[ace21]

try using the YEAR function that mysql provides.

update tbl set YEAR(end_date)=2001 where YEAR(end_date)=0000

Ace21