website stat

Finding and replacing on MySQL

Utterly useful function available on MySQL: REPLACE. It allows you to search and replace a certain string. I used it in order to change a few absolute URI references of this blog.

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');


No Responses to “Finding and replacing on MySQL”

Comments are closed.