Search string to SQL query converter
Algorithms adapted from an experimental advertising arbitrage search engine implemented in C#.
Designed for use as a microservice under Docker.
Searches are normally performed with "must contain" words. A match requires that all of the words entered be present on the page. You can search for a specific phrase by enclosing it in double quotes (").
You can explicitly search for pages which contain a specific word or phrase by prefixing it with an AND (+) sign. Only pages which contain that word or phrase will be shown.
You can search for pages that may contain a specific word or phrase by prefixing it with an OR (|) sign. Pages which contain that word or phrase will optionally be shown.
You can ignore all pages which contain a specific word or phrase by prefixing it with a NOT or minus (-) sign. Pages that contains that word or phrase will not be displayed in the search results. Note that negated phrases imply the presence of both words, but not as a phrase.
You can limit your search to a particular site by using the "SITE:" prefix before the full domain name.
All search words are case insensitive. Matches will be found in the page title, keywords, description and body text.
| Search String | Results pages will contain: |
|---|---|
| Online AND Security | both the word Online and the word Security |
| Online + Security | both the word Online and the word Security |
| Online OR Security | either the word Online or the word Security (or both) |
| Online | Security | either the word Online or the word Security (or both) |
| Online - Security | the word Online and not the word Security |
| - (Online | Security) | neither the word Online nor the word Security |
| "Online Security" | the exact phrase Online Security |
| Online - "Online Security" | the word Online, but not the exact phrase Online Security |
| Online SITE:www.AndrewM.com | the word Online from the site www.AndrewM.com |
| Online - SITE:www.AndrewM.com | the word Online, excluding pages from the site www.AndrewM.com |
| Internet - "Online Technology" SITE:www.AndrewM.com |
the word Internet, and not the phrase Online Technology, from the site www.AndrewM.com |