an example of what the others are saying:
UPDATE your_table
SET col_a = 'Some new value'
WHERE condition;
ALL rows meeting "condition" in the WHERE clause will be updated.
Many times the "condition" will be quite complex, so as to get all of the rows you want without getting rows you do not want.
"If a WHERE clause is too restrictive, not all target rows will be updated.
This problem can be avoided by eliminating the WHERE clause."
Discuss This Question: 4  Replies