SQL replace

Very handy SQL statement to replace part of a string that exists in multiple entries within a field of a table:

UPDATE table_name set field_name=replace(field_name, 'old_string', 'new_string')
where field_name LIKE '%old_string%'

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s