Home > Modification, MySQL, PHP, Programming, Script, Search Engine Optimization > Script To Rename Duplicate Fields In Mysql

Script To Rename Duplicate Fields In Mysql

January 13th, 2012

I’d like to resquest a PHP script that works the following:

I have a field called “title” in a table “my_table”. I have noticed there are some duplicate titles in diferent rows and I need to modify them for SEO purposes.
I need a script that will search for all duplicate titles in a way that it will add numbers to the duplicate titles, as exampled below:

Title to be verified: “Laptop computers” row #1
Number of duplicates found (same titles): 5 occurences (row #69, row #666, row #1009, …


Script To Rename Duplicate Fields In Mysql

Comments are closed.
Bear