Hi list, I am running MariaDB Server version: 10.4.17-MariaDB in Cent OS7. I have a column called from_addr from table msgs. Plz see its OUTPUT. select from_addr from msgs; +----------------------------------------------------------------+ | from_addr | +----------------------------------------------------------------+ | admin@sender.com | | userl@mysys.net | | Firstname Lastname <user622@yahoo.com> | | userl@mysys.net | | Firstname Lastname <user75@gmail.com> | | root@domain.net (root) | | userl@mysys.net | | userl@mysys.net | | Firstname Lastname <user75@gmail.com> | | userl@mysys.net | +--------------------------------------------------------------+ When Users send mails this from_addr column fills. some times with just email addresses, Some times email address with Display names. What I expect is to remove all the display name part. I only need email addresses. I expect from_addr column in this way. +--------------------------------------------+ | from_addr | +--------------------------------------------+ | admin@sender.com | | userl@mysys.net | | user622@yahoo.com | | userl@mysys.net | | user75@gmail.com | | root@domain.net | | userl@mysys.net | | userl@mysys.net | | user75@gmail.com | | userl@mysys.net | +--------------------------------------------+ How can I solve it. I tried a lot. But, I could NOT get what I expect. finally I subscribed to mariaDB mailing list. I need your INPUTS. -- cat /etc/motd Thank you Indunil Jayasooriya http://www.theravadanet.net/