Search code examples
azureazure-storageazure-table-storageazure-tablequery

Azure Table Storage Filter Query


I am trying to filter rows against a String Type column. Basically I wanted to filter with part of string. It is very similar to LIKE operation in MySQL.

I have gone through this document https://learn.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities

However, I couldn't find relevant information for my requirement. Any suggestion more helpful.


Solution

  • Basically I wanted to filter with part of string. It is very similar to LIKE operation in MySQL.

    Azure Tables have limited querying support and unfortunately LIKE is unsupported. What you would need to do is fetch all the entities on the client side and then apply the filter there.