Does anyone know a good algorithm to search a string on whole words only. For example, look for order and not order_line in a query.
This could be an useful addition to code search.
Solved
Algoritm to search for "Match whole words"
+5Best answer by Jasper
Something like this should work:
where '.' + column_to_search + '.'
like '%[^a-z_]search_term[^a-z_]%'This query adds a period before the column to take into account situations where the word is at the beginning or end, and then checks if the word is enclosed by characters other than a to z or underscore.
+16Maybe you can find some inspiration using for example scholar.google.com, I am pretty sure this is a well researched topic. A quick search led me to this overview, it states some different search techniques. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC61442/
- 678 replies
- Answer
Something like this should work:
where '.' + column_to_search + '.'
like '%[^a-z_]search_term[^a-z_]%'This query adds a period before the column to take into account situations where the word is at the beginning or end, and then checks if the word is enclosed by characters other than a to z or underscore.
- Captain
- 47 replies
Perhaps an option if you want to search on words is the use of FullText search:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.