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
REPLACE function will replace one string with another.
UPDATE YourTable SET name = REPLACE(name, "’", "'");
Answered By – Barmar
Answer Checked By – Timothy Miller (BugsFixing Admin)