import pymysql

conn = pymysql.connect(host='8.8.8.8', user='user', password='pass', db='bd',charset='cp1251', autocommit=True)
a = conn.cursor()
a.execute("UPDATE `list` SET `name` = REPLACE(`name`, ''', '%27')")