Search code examples
azureazure-cognitive-search

How Can i use Azure Search Like Syntax

In my Azure Search , i have two document , one column is call "Description"

And two record like this 

[ 
{"Description": "XARATM | KONE"},
{"Description": "ATM | RCOR"}
]

my problem is , when i use Azure Search to search my record like: 

https://myservice.search.windows.net/indexes/searchproduct/docs?search=ATM&api-version=2014-07-31-Preview

they just return one record {"Description": "ATM | RCOR"} , but i need two record. so can i use some syntax like T-SQL 

SELECT * FROM SearchProduct WHERE Description Like '%ATM%'

Thank you

Solution

  • Azure Search does support wildcards, but only in the format ATM*, that would allow to search for words in the form of suffixes such as ATMa or ATMb. In your case, you would need *ATM, which is not currently supported with Azure Search.

    To learn more about wildcards for suffix, please visit the MSDN API documentation on this topic here.

    Liam