I have a MySQL Database with myphpadmin access. 1 table called 'publications' has a column which has multiple authors separated by commas in each cell and hence will be a Many to Many relationship.
I need someone to go through and generate an authors and an authorspublications table based on this. You will also need to include the order of the names within the authorspublications table (in a ranking column).
There are many authors which are duplicates because some have extra spaces and ect. It would be great if you could also merge these duplicates under the same new author ID.
Feel free to ask any questions.
YOU WILL ONLY GET PHPMYADMIN ACCESS