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());删除掉试试。写了两次了，把第一个删除掉。