how extract email id below example (i.e. abc@abc.com, mno@mno.com, etc.)? each row can contains multiple email ids...
"abc" <abc@abc.com>; "xyz" <xyz@xyz.com>; pqr@pqr.com; "mno" <mno@mno.com>
in mysql use substring_index in following:
select substring_index(substring_index(id, '>', 1), '<', -1) email tbl; in sql server be:
select substring(id, charindex('<', id) + 1 , charindex('>', id) - charindex('<', id) - 1) tbl;
Comments
Post a Comment