Email ID filter using freetext sql server

Question

I cannot able to filter email from table using 'freetext' in sql server. For ex:

select *
from abc
where column = 'abc@gsd.com'

is getting all data having @ and .com think so.

Your query should return the desired result and exact match, It seems correct. Please share your table structure with sample data and the desired output. — Mukesh Arora, Apr 15 '20 at 12:10
sorry my query is - select * from abc where freetext(xyz,asb@email.com) — Balajisriram S, Apr 16 '20 at 02:36

score 0 · Answer 1 · answered Apr 15 '20 at 12:37

0

Hope this Query Works fine for your Case:

SELECT * FROM ABC WHERE COLUMN LIKE '%@%.com'

Thanks

answered Apr 15 '20 at 12:37

Thiyagu

1 Answers1