I have a mysql database, in which one of the columns is called "Aliases".
I need a query that I can run in phpmyadmin which will search for any exact duplicates of those aliases and present them to me so I can edit them.
For example if there are two aliases named mickey-mouse then that could be considered duplicates and I want to just see those duplicates in the results of the query. if there was also a mickey-mouse-club then that would not be an exact match and I don't want to see that included in the mickey-mouse match results.
Editing them is no problem. I just want to easy find those duplicates so I can make the appropriate fix by hand.
I'm using phpmyadmin Version information: 4.2.10,
I have a backup of my database. all aliases are lower case and have no spaces -- just-dashes-between-words.
I have about 1000 records and just a few of them have duplicate aliases -- so a query would help me take care of this task.
I've used phpmyadmin for years, but am not a database pro like you people are.
The search is all within one table, which we can call bananas_content ....