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 | +----------------------------------------------------------------+ | [email protected] | | [email protected] | | Firstname Lastname <[email protected]> | | [email protected] | | Firstname Lastname <[email protected]> | | [email protected] (root) | | [email protected] | | [email protected] | | Firstname Lastname <[email protected]> | | [email protected] | +--------------------------------------------------------------+ 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 | +--------------------------------------------+ | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | | [email protected] | +--------------------------------------------+ 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 : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

