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 | +----------------------------------------------------------------+ | ad...@sender.com | | us...@mysys.net | | Firstname Lastname <user...@yahoo.com> | | us...@mysys.net | | Firstname Lastname <use...@gmail.com> | | r...@domain.net (root) | | us...@mysys.net | | us...@mysys.net | | Firstname Lastname <use...@gmail.com> | | us...@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 | +--------------------------------------------+ | ad...@sender.com | | us...@mysys.net | | user...@yahoo.com | | us...@mysys.net | | use...@gmail.com | | r...@domain.net | | us...@mysys.net | | us...@mysys.net | | use...@gmail.com | | us...@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/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
