Nov 8, 2018

Example usage of replace function in MySQL

update template t set html= replace(html, 'www.i88.ca','it.i88.ca') where t.html like '%www.i88.ca%';