I often have to search and replace through lots rows in MySQL, so this is useful: update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find this string', 'replace found string with this string'); A good example of this is replacing URL strings in CMS databases. I'll show a simple Magento one. Magento stores all the URLs in … Continue reading Search and replace for MySQL
