Experienced an issue with the Plugin Register Plus which has been writing User URLs to the wrong table in the database, the upshot being that users cannot then update their URL from the admin panel of WordPress once registered.
This issue is now fixed for future registrations, however, users still cannot update their URLs.
I'd like the SQL to run in PHPMyAdmin which will do the following:
1) Copy the data from the usermeta table with a meta key of "user_url" to the users table under "user_url" IF there exists no entry in that table already.
2) I then want to delete ALL entries in the usermeta table that have a meta key of "user_url".
Please can someone with more SQL knowledge than I assist with the query I should be running here!