String SQL="select * from soccer_manager_dispose where user_id=user_id and players like '%"+player_id+"%'";
like '%"+player_id+"%'";这肯定不行 如果是10010 则1001也包含了 所以我才在id号的两边都加上了#符号 现在要包含#player_id#才行 但我不知道语法怎么写 是like '%‘#’+player_id+‘#’%'这样吗?
String SQL="select * from soccer_manager_dispose where user_id=" + user_id + "and players like '%#" + player_id +"#%'";如果不行的话,调试一下,看SQL的值是什么
String SQL="select * from soccer_manager_dispose where user_id=user_id and players like '%#"+player_id+"#%'";
String SQL="select * from soccer_manager_dispose where user_id=user_id and players like '%#'+player_id+'#%' and len(players) = " + player_id.Trim().Length;//这里要注意汉字的问题 //另外我取的是相同长度,你可以取小于或者大于,etc.,
like '%"+player_id+"%'";这肯定不行 如果是10010 则1001也包含了这个问题绝对不会出现 '1001' like '%10010%' 是假的这样的话,12楼的答案是对的
String SQL="select * from soccer_manager_dispose where user_id=user_id and players like '%"+player_id+"%'" + "and len(players) = " + player_id.Trim().Length; ;拷贝错了,应该是这样。先like、再比较长度
所以我才在id号的两边都加上了#符号 现在要包含#player_id#才行 但我不知道语法怎么写
是like '%‘#’+player_id+‘#’%'这样吗?
//另外我取的是相同长度,你可以取小于或者大于,etc.,
;拷贝错了,应该是这样。先like、再比较长度