[SOLVED] How to replace ST. MARY’S with ST. MARY'S

Issue

I’ve varchar string stored in MYSQL Database ; I want to replace all ST. MARY’S with ST. MARY'S .
If you notice there is difference of ’ and '.

Solution

The REPLACE function will replace one string with another.

UPDATE YourTable
SET name = REPLACE(name, "’", "'");

Answered By – Barmar

Answer Checked By – Timothy Miller (BugsFixing Admin)