Quote:
Originally Posted by natkejs
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. |
Yeah but that is changing the data in the table and he said he did not want to do that.
.