Not very familiar with SQL, need to replace data in column

I have a table that has a column with the option weight for all products that is set to 0.00000 and I want to change them all to 0.5

What would the correct command be?

Thanks for the help.

 

Use the following UPDATE query

UPDATE table_name SET 
column_name = 0.5

Code (markup):

To be on safe side backup your data before running this query

 

Thanks that worked great.

 

you are welcome