CODEWITHSUNDEEP
sqlsql-server
user4156123
user4156123

Reputation:

How to Extract only email id in SQL SERVER

How to extract only Email Id from the below example (i.e. [email protected], [email protected], etc.)? Each row can contains multiple Email IDs...

"ABC" <[email protected]>; "XYZ" <[email protected]>; [email protected]; "MNO" <[email protected]>

Upvotes: 3

Views: 2187

Answers (3)

Stanislovas Kalašnikovas
Stanislovas Kalašnikovas

Reputation: 9053

In MySQL you could use SUBSTRING_INDEX in following:

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(Id, '>', 1), '<', -1) Email
FROM Tbl;

In SQL Server will be:

SELECT SUBSTRING(Id, CHARINDEX('<', Id) + 1 , CHARINDEX('>', Id) - CHARINDEX('<', Id) - 1)
FROM Tbl;

Upvotes: 1

Mukesh Kalgude
Mukesh Kalgude

Reputation: 4844

In sql server run this query

SELECT SUBSTRING ( Emailcolumn ,CHARINDEX('<',Emailcolumn )+1
 , CHARINDEX('>',Emailcolumn )-CHARINDEX('<',Emailcolumn )-1)

Upvotes: 0

Sadikhasan
Sadikhasan

Reputation: 18600

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(email,'>',1),'<',-1) AS EmailID
FROM table_name;

Upvotes: 1

Related Questions