mysql - Which SQL command should I use to replace specific values? -

i have numeric values below:

0
2323
1003

i have replace only single zeros 100. tried following code affects other values include 0.

update table_name set field_name= replace(field_name,"0","100"); 

the values should below after transaction:

100
2323
1003

which sql command should use?

thanks.

you should use where clause instead of replace.

update table_name set field_name = 100 field_name = 0