sqlite - 如何在 sqlite 中转义 % 符号？

Question

我使用 LIKE 子句进行全文搜索，文本可以包含“%”。

在 sqlite 数据库中搜索 % 符号的好方法是什么？

我试过了

SELECT * FROM table WHERE text_string LIKE '%[%]%' 

但这在 sqlite 中不起作用。

Answer 1

来自SQLite documentation

If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must evaluate to a string consisting of a single character. This character may be used in the LIKE pattern to include literal percent or underscore characters. The escape character followed by a percent symbol (%), underscore (_), or a second instance of the escape character itself matches a literal percent symbol, underscore, or a single escape character, respectively.