Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Mysql Trimming numbers at end of email?
Hey, I know a bit about sql but now I have to write a query that will remove all numbers after an email address, looking like this biotech1@atlantic.net #5.7.1 or like this oglesby@blueridge.net l6YDv7150556530900. Also some with ip's at the end. The file has to be stripped of this info before we send it out. So far, all I have is
Select emails
From emails
And then I was thinking doing trim where(wild card any number after .com, .org, etc) but I can't get it to work right. Help please, what should the code look like?
