正确的写法:
sqlContent.Append(" AND column1 LIKE @param1 ");
// 添加参数
paramList.Add(new MySqlParameter("@param1", "%" + strParam1+ "%"));
错误的写法:
sqlContent.Append(" AND column1 LIKE ‘%@param1%‘ ");
// 添加参数
paramList.Add(new MySqlParameter("@param1", strParam1));
转载于:https://www.cnblogs.com/xrtd/p/3859283.html