How do I search for exactly my search phrase

FwebbFwebb 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:
· Share on Twitter

Answers

  • Jon_KirkwoodJon_Kirkwood Posts: 420 Silver 5
    Hi @Fwebb

    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

    Jon Kirkwood | Technical Support Engineer | Redgate Software
    · Share on Twitter
Sign In or Register to comment.