You can replace or update easily phpMyAdmin data with the below command: update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'old txt', 'new txt');