Options
How do I search for exactly my search phrase
Fwebb
Posts: 1 New member
in SQL Search
I am searching for GA PICKING and only want that result returned. I am getting GA, PICKING, not just "GA PICKING"
Tagged:
Fwebb
Posts: 1 New member
Answers
Thank you for reaching out on the Redgate forums.
Regarding your SQL Seach query - the best method is to enable the 'Match whole words only' when searching for multi-word phrases.
However as you are finding, the comma (,) is ignored. My understanding behind this behavior is that it is connected to how the text is parsed using comma-separated values. So when the , is ignored GA, PICKING & GA PICKING are both going to hit as a match in your search results.
If this is a major concern on your usage of SQL Search I may suggest posting a feature request on our UserVoice page. This page allows users of Redgate software to highlight features or functions that can enhance our software to be better usable.
For SQL Search the UserVoice link is https://redgate.uservoice.com/forums/101149-sql-search