日期:2014-05-16 浏览次数:20470 次
select * from A where A.data like '%50\%% escape '\'
select * from A where A.data like '%50\\\%% escape '\'
if(keyword.contains("%") || keyword.contains("_")){
keyword = keyword.replaceAll("\\", "\\\\")
.replaceAll("\\%", "\\\\%")
.replaceAll("\\_", "\\\\_");
}