How to convert HTML character references in MySQL? -

in 1 old database have html character references like: 展览 how can convert them valid utf8 characters (展览 -> 展览)?

i know e.g. php func html_entity_decode this, amount of data big pass , fourth php

match regexp, cast int , cast code-point? possible?

as joop eggen says, make dump of table need convert , convert file bash program recode

example:

dumping db mydb.sql file

mysqldump -uroot -p mydb > mydb.sql

converting html entities utf8

recode html..utf8 mydb.sql

now mydb.sql converted

KHS