sql 语句问题

[qian6688099]

我在c# 中想写一条sql语句
,查询出包含 . 的数据
string sql="select * from ftpFileUpdate where filename like '%.%'";

提示我''附近有语法错误，应该怎样写？

请大侠帮忙

[wangoqoq]

string sql=@"select * from ftpFileUpdate where filename like '%.%'";

[空心兜兜]

注意转义符

[dulei123321]

要要逃逸字符 string sql="select * from ftpFileUpdate where filename like '%.%' cscape '.' ";

[dulei123321]

迅速 结贴吧

[love07081403]

string a="%.%";
string sql="select * from ftpFileUpdate where filename like "+a;

[子夜__]

'替换成"

转义

replace(,)

[moshuyouke]

stirng @condition=".";
string sql="select * from ftpFileUpdate where filename like %"+@condition+"%";

[mayanly]

中文的‘应该是英文的'