Script To Rename Duplicate Fields In Mysql

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, …

Leave a Reply

Your email address will not be published. Required fields are marked *