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.
- - , .
.
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 313
تاريخ: يکشنبه
27 تير
1395 ساعت: 9:31