Search
Query the Bing search engine.
Table Specific Information
Select
When querying this table, the Bing API requires the SearchTerms parameter. For example, to search Bing for the term 'bing' use the following query:
SELECT * FROM Search WHERE SearchTerms = 'bing'
You can also specify a SearchType:
SELECT * FROM Search WHERE SearchTerms = 'bing' AND SearchType = 'Images'
For a high-performance retrieval the Total Estimated Matches for a search, you may issue a count(*) with the SearchTerms parameter only.
SELECT count(*) FROM Search WHERE SearchTerms = 'bing'
Columns
| Name | Type | Description |
| Id | String | An ID that uniquely identifies the web answer. |
| SearchType | String | The type of the search result.
The allowed values are WebPages, Images, News, Videos. |
| Title | String | The title of the search result. |
| URL | String | The URL of the search result. |
| DisplayUrl | String | The displayed link of the search result. |
| ContentUrl | String | The source URL of the search result. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SearchTerms | String | The search expression. |
| Market | String | The market where the results come from.
The allowed values are ar-XA, bg-BG, cs-CZ, da-DK, de-AT, de-CH, de-DE, el-GR, en-AU, en-CA, en-G, en-ID, en-IE, en-IN, en-MY, en-NZ, en-PH, en-SG, en-US, en-XA, en-ZA, es-AR, es-CL, es-MX, es-US, es-XL, et-EE, fi-FI, fr-BE, fr-CA, fr-CH, fr-FR, he-IL, hr-HR, hu-HU, it-IT, ja-JP, ko-KR, lt-LT, lv-LV, nb-NO, nl-BE, nl-NL, pl-PL, pt-BR, pt-PT, ro-RO, ru-RU, sk-SK, sl-SI, sv-SE, th-TH, tr-TR, uk-UA, zh-CN, zh-HK, zh-TW. |
| SafeSearch | String | The search safety level.
The allowed values are Strict, Moderate, Off. |