CODEWITHSUNDEEP
mysql
Pawan Mude
Pawan Mude

Reputation: 1659

How to replace ’ with ' in MySQL DB?

I've around 10000 records stored in MYSQL Database. I want to replace ’ with ' in a given table of MySQL DB (for all columns) Can you please suggest how it can be done?

Upvotes: 1

Views: 67

Answers (2)

SKG
SKG

Reputation: 510

First of all export your database then open it in text editor then find the string and then replace it with your new string and import db

Upvotes: -1

Rahul Tripathi
Rahul Tripathi

Reputation: 172408

You may try like this:

UPDATE table1 SET columnname = REPLACE(columnname, '\’', ''');

Also check the Special Character Escape Sequences

Upvotes: 2

Related Questions