This topic created in 2288 days ago, the information mentioned may be changed or developed.
现在有个业务代码里有 like “XXX_%” 前缀匹配。但是 _ 这个符号会被认为是通配符，其实我想将它当作字符串匹配。百度了下，没有搜到我想要的答案，所以在这里跟大家请教下
 |
1
wework Jan 21, 2020
Try \%
|
 |
2
manami Jan 21, 2020
\_
|
 |
3
Waterchestnut OP @wework 感谢老哥～果然可以～
|
|
4
Waterchestnut OP @manami 谢谢老哥，这个方法可行～
|
|
5
wework Jan 21, 2020
@Waterchestnut sure , we work , no problem
|
|
6
manami Jan 21, 2020
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
官方有写到“\_ matches one _ character.” |
|
9
Waterchestnut OP @wework niu bi，kao pu
|
 |
10
jugelizi Jan 21, 2020
所以 你在拼接 sql 语句！
|
 |
11
wutongshuVVV Jan 21, 2020
@jugelizi 盲生发现了华点（ doge
|
Select Language