Category: MySQL

MySQL replace function – Find and replace values in database with sql

A great piece of sql that can save you a lot of time. The replace sql function finds and replaces values in a database. Just fill in the table_name, table_field, the value your searching for and with which value you want to replace it with. UPDATE table_name SET table_field = REPLACE(table_field, 'value', 'new_value') WHERE my_field … Continue reading MySQL replace function – Find and replace values in database with sql