如何在Azure DocumentDb上进行不区分大小写的搜索? [英] How to do a Case Insensitive search on Azure DocumentDb?

问题描述

是否可以在DocumnetDb上执行不区分大小写的搜索?

is it possible to perform a case insensitive search on DocumnetDb?

假设我有一条记录，记录中带有名称"键，其值为"Timbaktu"

Let's say I have a record with 'name' key and value as "Timbaktu"

这将起作用:

select * from json j where j.name  = "Timbaktu"

这不会:

select * from json j where j.name  = "timbaktu"

那么如何进行不区分大小写的搜索?

So how do yo do a case insensitive search?

谢谢.

致谢.

推荐答案

有两种方法可以做到这一点. 1.使用内置的LOWER/UPPER功能，例如

There are two ways to do this. 1. use the built-in LOWER/UPPER function, for example,

select * from json j where LOWER(j.name) = 'timbaktu'

这将需要扫描.另一种更有效的方式是存储规范化"形式，例如并将其用于查询.例如，JSON为

This will require a scan though. Another more efficient way is to store a "canonicalized" form e.g. lowercase and use that for querying. For example, the JSON would be

{ name: "Timbaktu", nameLowerCase: "timbaktu" }

然后使用它进行查询，例如:

Then use it for querying like:

select * from json j WHERE j.nameLowerCase = "timbaktu"

希望这会有所帮助.

这篇关于如何在Azure DocumentDb上进行不区分大小写的搜索?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！