ODBC guide

Search documents from index

Runs a full-text search on an index (or alias) using the Elasticsearch query DSL. Pass the query JSON in the WITH clause (e.g. Query='{"match": { "comment" : "TV" } }'). For more options see the Elasticsearch query DSL.

SELECT * FROM MyIndexOrAliasName WITH(Query='{"match": { "comment" : "TV" } }')
		
		--or use below - slight faster (avoids table / alias list validation)
		--SELECT * FROM search WITH(Index='MyIndexName', Query='{"match": { "comment" : "TV" } }')
		--SELECT * FROM search WITH(Index='MyIndexName', Alias='MyAliasName', Query='{"match": { "comment" : "TV" } }')