什么是T-sql的LIKE命令的等效表存储查询? [英] What is the azure table storage query equivalent of T-sql's LIKE command?

问题描述

我正在使用Azure存储资源管理器查询Azure表存储.我想查找包含给定文本的所有消息，例如在T-SQL中:

I'm querying Azure table storage using the Azure Storage Explorer. I want to find all messages that contain the given text, like this in T-SQL:

message like '%SysFn%'

执行T-SQL时显示处理此请求时发生错误"

Executing the T-SQL gives "An error occurred while processing this request"

Azure中此查询的等效项是什么?

What is the equivalent of this query in Azure?

推荐答案

没有直接等效项，因为没有通配符搜索. 此处列出了所有受支持的操作.您会看到eq，gt，ge，lt，le等.也许可以利用这些来查找特定范围.

There's no direct equivalent, as there is no wildcard searching. All supported operations are listed here. You'll see eq, gt, ge, lt, le, etc. You could make use of these, perhaps, to look for specific ranges.

根据您的分区方案，您也许可以基于特定的分区键选择一个实体子集，然后遍历每个实体，检查message以找到所需的特定对象(基本上是部分分区扫描)

Depending on your partitioning scheme, you may be able to select a subset of entities based on specific partition key, and then scan through each entity, examining message to find the specific ones you need (basically a partial partition scan).

这篇关于什么是T-sql的LIKE命令的等效表存储查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！