something about"like"

longhaitao <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <784575131.95701196645258578.JavaMail.coremail@bj163app110.163.com>
 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%'";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar, 45, "BuyerName");
para.Value = blurName;
It didn't work.
I changed that like this:
string commd = "select * from buyerinfo where BuyerName like '%"+"?blurName"+"%'";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar, 45, "BuyerName");
para.Value = blurName;
 or:
blurName="'%"+"blurName"+"%'";
string commd = "select * from buyerinfo where BuyerName like ?blurName";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar, 45, "BuyerName");
para.Value = blurName;
It also didn't work, when executed ,It returned nothing ,which definitely wrong.
Any advise would be appreciated,thx!
--
Best regards!
haitao
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.