Asp.net 链接mySQL 使用like查询

Question

Asp.net 链接mySQL 使用like查询

mysql 查询器中正常

 asp.net 返回没有结果，问各位大神这是为什么？

Answer 1

StringBuilder sb = new StringBuilder();                         sb.Append("select * from Friend_UserSiteInfo where IsDel=0");             StringBuilder sbCondition = new StringBuilder();            if (friendID != 0)             {                 sbCondition.AppendFormat(" AND FriendID={0}", friendID);             }            if (!string.IsNullOrEmpty(friendSiteName))             {                 sbCondition.AppendFormat(" AND FriendSiteName Like '%{0}%'",friendSiteName);             }            if (type !=0)             {                 sbCondition.AppendFormat(" AND CooperationMode ={0}", type);             }             sb.Append(sbCondition.ToString());             sb.AppendFormat(" limit {0},{1} ;", ((pageIndex - 1) * pageSize), pageIndex * pageSize);             sb.Append(" SELECT COUNT(0) FROM Friend_UserSiteInfo  WHERE  IsDel=0 ");             sb.Append(sbCondition.ToString());

Answer 2

sb.Append(sbCondition.ToString());             sb.AppendFormat(" limit {0},{1} ;", ((pageIndex - 1) * pageSize), pageIndex *pageSize);把这个sb.Append(sbCondition.ToString());删除掉试试。写了两次了，把第一个删除掉。