android - 更正 Android SQLite 中 GLOB 空格的语法

Question

我正在尝试构建一个包含空格的 glob 模式。我试过 \\ (转义，因为它是 java 加空格)，[\\] 和 [[:space:]]。我不知道如何实现这个。这看起来简单而愚蠢，但我没有找到任何关于这个的文档(sqlite glob 实现)。

我不能使用 LIKE，因为我的其余表达式使用字符排列([a-d] 等)

Answer 1

GLOB 文档隐藏在源代码中:

Globbing rules:

     '*'       Matches any sequence of zero or more characters.

     '?'       Matches exactly one character.

    [...]      Matches one character from the enclosed list of
               characters.

    [^...]     Matches one character not in the enclosed list.

With the [...] and [^...] matching, a ']' character can be included
in the list by making it the first character after '[' or '^'.  A
range of characters can be specified using '-'.  Example:
"[a-z]" matches any single lower-case letter.  To match a '-', make
it the last character in the list.

Hints: to match '*' or '?', put them in "[]".  Like this:

        abc[*]xyz        Matches "abc*xyz" only

---

一个空格可以只匹配模式中的一个空格:

> SELECT ' ' GLOB ' ';
1