load data local infile & update

[Adrian Cazan]

Hello,

Please help with loading a csv into a db.

csv file:
a,1
b,0
c,1
......


is it posible to load this file into a db and to condition by second column.
for example if value 1 then new, if value 0 then old

At the end the db should be like:
a,new
b,old
c,new
.......

Thank you