[Mono-list] problem about "like"

[Robert Jordan]

billow dragon wrote:
> hi,guys:
> 
> Now i am in this situation:I want to use the cause "like",i wrote:
> string commd = "select * from buyerinfo where BuyerName like '%?blurName%'";

string commd = "select * from buyerinfo where BuyerName like ?blurName";

> MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar,
> 45, "BuyerName");
> para.Value = blurName;

MySqlParameter para = new MySqlParameter("?blurName",
MySqlDbType.VarChar, 45, "%BuyerName%");

Robert