SQL LIKE +变量问题

[langkun611]

如题 不想写 存储过程 想直接 SQL


string Key
SELECT * FROM tb_User u，tb_News n WHERE u.Name Lik’+??' AND ...
多条件的..

[q107770540]

string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";

[流苏1990]

同意楼上

[ToMakeLove]

[Quote=引用 1 楼 q107770540 的回复:]

string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";
[/Quote]同意此回答

[langkun611]

提示字符过多... 条件很多..

[q107770540]

string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE u.Name Like ’%"+Key+"%'
AND u.FirstName like '%"+Key+"'%";

[langkun611]

[Quote=引用 1 楼 q107770540 的回复:]
string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";
[/Quote]
SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE'%' + KeyWord + '%' AND a.Description LIKE'%' + KeyWord + '%' AND a.Broadcast LIKE'%' + KeyWord + '%' AND a.Name LIKE'%' + KeyWord +'%' AND n.NovName LIKE'%' + KeyWord + '%' ORDER BY a.CreatTime DESC"


求解....

[停停走走]

你用inner join 查询一下试试三张表联合查询

[lchy110]

[Quote=引用 6 楼 langkun611 的回复:]
引用 1 楼 q107770540 的回复:
string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";

SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.Categ……
[/Quote]

你的看清一楼给你解决方法形式 你这样当然是不对 人家是在一个字符串里

            string sql = "SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE '%" + KeyWord + "'% AND a.Description LIKE '%" + KeyWord + "'% AND a.Broadcast LIKE '%" + KeyWord + "'% AND a.Name LIKE '%" + KeyWord + "'% AND n.NovName LIKE '%" + KeyWord + "'% ORDER BY a.CreatTime DESC";

[q107770540]

string Key
string sql="SELECT * FROM tb_User u，tb_News n WHERE 1=1"
sql+=" AND u.Name Like ’%"+Key+"%'";
 sql+=" AND AND u.FirstName like '%"+Key+"'%";
 就这样写好了 下边你懂的

[lchy110]

写错了 呵呵 不好意思

            string sql = "SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE '%" + KeyWord + "%' AND a.Description LIKE '%" + KeyWord + "%' AND a.Broadcast LIKE '%" + KeyWord + "%' AND a.Name LIKE '%" + KeyWord + "%' AND n.NovName LIKE '%" + KeyWord + "%' ORDER BY a.CreatTime DESC";

[langkun611]

[Quote=引用 7 楼 hongjiazhang 的回复:]
你用inner join 查询一下试试三张表联合查询
[/Quote]
新人不会..