There are two practical methods suggested:
1st solution: save/copy the database table and
- – use text editor’s “search and replace” function and fill table with new content;
- – remove (empty) old table from database
- – upload new/modified table to database
2nd solution , use MySQL REPLACE function:
UPDATE table_name SET column_name =
And that’s it, happy coding !