Change column of all records where column is a certain value

[#1]

Hi community,

Is there away to change the value of a colum in a table if another column has a different value?

Lets say I want all records where column 3 equals 6010 to have column 1 values be changed to 1000.  How would I do that and have it fit with eveything else in my document?

[MayilVahanan]

HI

Try like this in script

Load  *, if(Column3 = 6010, 1000,Column1) as Column1 from tablename;

Hope it helps