CODEWITHSUNDEEP
phpmysqlphpmyadmininvision-power-board
user6002820
user6002820

Reputation:

How do I replace a letter with another letter in phpmyadmin?

I am new here and please excuse me if I'm asking my question wrong or whatever.

I converted my old forum which was vbulletin to invision power board and I noticed that I have a turkish character problem in my forum:

ğ = ð
ı = ý
ş = þ

^They are looking like that and I need to fix this, unfortunately the support can't help me with this, since the issues was caused on vbulletin, so I have to fix it by myself and I thought I could just replace the wrong letters with the correct one, but ipb doesn't support such a function so I must do it in the db. So here is my question, is there a way to do it through phpmyadmin? Just replace the wrong letters with the right now?

Upvotes: 0

Views: 216

Answers (2)

awinwood
awinwood

Reputation: 135

Have a look at the following in MySQL using a replace() in your query, you can change the characters providing you have the correct character set.

UPDATE table
SET colname = REPLACE(colname, 'ğ', 'ð')
WHERE ...

Upvotes: 0

Orion
Orion

Reputation: 125

Run this command on the individual tables

UPDATE table_name SET column_name = REPLACE (column_name, 'Item to replace here', 'Replacement text here');

Upvotes: 1

Related Questions