Quick Tip: MySql Replace

While looking for ways to improve my MySQL queries, I can across the REPLACE function. This post shows are to use replace in INSERT, and UPDATE SQL queries.

Insert Statement

SELECT field1,
      REPLACE(stringVar, 'search for', 'string to replace with') AS field2,
      field3
FROM testdb

Update Statement

UPDATE testDB2
SET stringVar = REPLACE (stringVar, 'search for', 'string to replace with')
WHERE id=1