how to replace table field value.?

i had a database name “q8marketz” there is a table “product”, inside this table had many fields eg:- product id, model, quantity, shipping, etc…

i had uploaded many products my table… there is a field “shipping”, this “shipping” value for all product is i set already " 1 " , so now i want replace all product shipping value to " 0 " .

anybody can help me.?
sorry my english not perfect…

Hi mansabbas,

To change the shipping column’s value to 0 for every single product in your table, try the following query:

UPDATE `q8marketz` SET `shipping` = 0
Sponsor our Newsletter | Privacy Policy | Terms of Service