Azure Table Storage Filter Query

Question

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.

score 1 · Accepted Answer · answered Oct 19 '17 at 15:46

1

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.

answered Oct 19 '17 at 15:46

Gaurav Mantri

128,066
12
206
241

i have millions of rows it is very difficult to handle those at client side. is there any other options? – HILARUDEEN S ALLAUDEEN Oct 19 '17 at 15:49
If you're looking for strings that starts with certain characters, then there's a way otherwise it's not possible to perform the searches using `LIKE` like functionality. – Gaurav Mantri Oct 19 '17 at 15:56
it is look like there is support pattern matching in azure table text as of now and accepting – HILARUDEEN S ALLAUDEEN Nov 08 '17 at 07:00
Can you share more details? – Gaurav Mantri Nov 08 '17 at 07:03
sorry there was typo in my previous comment. I agreed there is no support for pattern matching. i have accepted your for the same only. thanks – HILARUDEEN S ALLAUDEEN Nov 08 '17 at 07:09
You got me worried there for a second :). Thanks for clarifying. – Gaurav Mantri Nov 08 '17 at 07:10

Azure Table Storage Filter Query

1 Answers1