Tuesday 29 December 2015

MySql replace function 

UPDATE MyTable

SET StringColumn = REPLACE (StringColumn, 'SearchForThis', 'ReplaceWithThis')

WHERE SomeOtherColumn LIKE '%PATTERN%'
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)