原文:
sql 模糊查询带下划线的字段 _1、SELECT * FROM dbo.tb_Test
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZlBnaugDZkRTMkFDN2YTNyMDMilDZ1czMwgDZmVTYmFjYwUmNfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.jpeg)
2、SELECT * FROM dbo.tb_Test WHERE name LIKE '%c_%'
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZlBnaugDZkRTMkFDN2YTNyMDMilDZ1czMwgDZmVTYmFjYwUmNfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.jpeg)
3、SELECT * FROM dbo.tb_Test WHERE name LIKE '%c_%' escape '\'
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZlBnaugDZkRTMkFDN2YTNyMDMilDZ1czMwgDZmVTYmFjYwUmNfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.jpeg)
4、SELECT * FROM dbo.tb_Test WHERE name LIKE '%c\_wd' escape '\'
以上是我的测试数据,只有第四个符合要求(escape '\')