I have a MySQL database that was created from data output by another application.
On of the columns is for an email address, however the data in this column is all duplicates.
For example, the "email" for a single record looks like this "[email protected],[email protected]".
I would like the field to contain the address just once.
Is there a way through a MySQL command, to remove anything from the , onward?
I know I can write a PHP script to loop through all the data, but i was hoping there was a simpler way through MySQL.
برچسب:
نویسنده: استخدام کار