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

Question

Ex [e-mail] [e-mail] and [e-mail] I have to only get Gmail yahooo

Answer 1

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 '[e-mail]'
or t.emails like '[e-mail]'