SQL Server word-level bigram function
I work for an online auction website, Trade Me, and as such collect quite a large quantity of search data (i.e. full text searches that people perform). Over the years I’ve been involved in various …
search
Full-Text Search Operators – Part 4: Wrapping it up
Part 1: Cleaning up parentheses in a stringPart 2: Replacing alternate operatorsPart 3: Splitting the search string Gee, it’s been over a month since my last post already! Since then we’ve been crazy-busy at work, …
Full-Text Search Operators – Part 4: Wrapping it up Read More »
Full-Text Search Operators – Part 3: Splitting the search string
Part 1: Cleaning up parentheses in a string Part 2: Replacing alternate operators We’ve now got to the point where we have a “clean” search string. The next step is to split the string into …
Full-Text Search Operators – Part 3: Splitting the search string Read More »
Full-Text Search Operators – Part 2: Replacing alternate operators
In this post I’m going to deal with another piece of the puzzle that I described in part 1. Now, after re-reading that post it became obvious that I probably need to outline what the …
Full-Text Search Operators – Part 2: Replacing alternate operators Read More »
Full-Text Search Operators – Part 1: Cleaning up parentheses in a string
Part 1: Cleaning up parentheses in a string Part 2: Replacing alternate operators Part 3: Splitting the search string Part 4: Wrapping it up A few years ago I wanted to have a crack at …
Full-Text Search Operators – Part 1: Cleaning up parentheses in a string Read More »