Replace values in table

Alter value in one field, all rows of a table

[abbeyvet]

I am not good with MySQL but I think there must be a simple way in PHPMyAdmin to do what I need to do.

Basically I have a table of products, a few thousand of them, and they all have a value in the field pWeight of 0. I want to change them to all have a value of 1.

I could go through the lot and edit each record, but I am sure there must be a quicker and simpler way to do it.

[coopster]

UPDATE myTable SET pWeight = 1;

I always make a backup of tables before doing something like this, you may want to do the same!

[abbeyvet]

:) Thank you, that saved hours.