Aug 252010
Replace string in MySQL
Answer:
Replace a string with the UPDATE statement is easy in MySQL
E.g.
mysql> UPDATE table1 SET name = REPLACE (name, 'foo', 'bar');
Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.
Replace string in MySQL
Answer:
Replace a string with the UPDATE statement is easy in MySQL
E.g.
mysql> UPDATE table1 SET name = REPLACE (name, 'foo', 'bar');
