+ 1

I have one mail account table I have to insert 4 accounts I would get the account are Gmail yahoo and hotmail

Ex xxxc@gmail.com yyyy@yahoo.com and zzzz@hotmail.com I have to only get Gmail yahooo

27th Nov 2018, 10:32 AM
Pavi Kutty
1 Answer
+ 11
If I get it right you are trying to query only gmail or yahoo emails. I'm assuming that you are working in sql. Select would be like this select * from dbo.table t where t.emails like '%@gmail.com' or t.emails like '%@yahoo.com'
30th Nov 2018, 10:26 PM
r8w9
r8w9 - avatar