SQL Server 转义下划线

2021-12-02 00:00:00 sql-server

如何转义下划线字符?

我正在编写类似于以下 where 子句的内容，并希望能够找到末尾带有 _d 的实际条目.

I am writing something like the following where clause and want to be able to find actual entries with _d at the end.

Where Username Like '%_d'

推荐答案

LIKE 的 T-SQL 参考:

您可以使用通配符模式匹配字符作为文字字符.要将通配符用作文字字符，请将通配符括在方括号中.下表显示了使用 LIKE 关键字和 [ ] 通配符的几个示例.

You can use the wildcard pattern matching characters as literal characters. To use a wildcard character as a literal character, enclose the wildcard character in brackets. The following table shows several examples of using the LIKE keyword and the [ ] wildcard characters.

对于您的情况:

... LIKE '%[_]d'

相关文章