Quote:
Originally Posted by ZTT
UPDATE table SET pets = 'zombie';
|
This, and you can mimic replace behavior with a where statement.
Code:
UPDATE table SET pets = 'zombie' WHERE pets = 'cat';
Or if you're replacing multiple values
Code:
UPDATE table SET pets = 'zombie' WHERE pets IN ('cat','dog','mouse');
But this is only for columns holding single term values. If you are replacing words inside strings then you need to use the REPLACE statement.