SELECT * FROM TEST T WHERE T.D_NAME LIKE '%%%'; SELECT * FROM TEST T WHERE T.D_NAME LIKE '%_%'; 避免模糊查询在前后%号中间出现 %和_ 否则查询的数据就是所有
转载于:https://www.cnblogs.com/aspnet_csharp/archive/2012/04/18/2455630.html
SELECT * FROM TEST T WHERE T.D_NAME LIKE '%%%'; SELECT * FROM TEST T WHERE T.D_NAME LIKE '%_%'; 避免模糊查询在前后%号中间出现 %和_ 否则查询的数据就是所有
转载于:https://www.cnblogs.com/aspnet_csharp/archive/2012/04/18/2455630.html