从列表搜索数据
问题说明
我在storeprocedure中编写了这个查询。但是使用这个我只能用完整的文本搜索数据。例如：我可以搜索名称为'''ronak''的数据。我无法搜索名称以''开头的数据R ''。
请帮我解决这个问题。
SELECT profile .name1 AS name，profile.address，profile.mob_no，profile.emailid，login.username
FROM profile INNER JOIN
登录ON profile.log_id = login.log_id
WHERE（profile.name1 LIKE @ name1）或
（profile.mob_no LIKE @mob_no）或
（profile.emailid LIKE @emailid）或者
（login.username LIKE @username）
我尝试了以下2解决方案，但是当我写查询时
SET @ name1 =''％'' @ name1 ''％''
SELECT profile.name1 AS name，profile.address，profile.mob_no，profile.emailid，login.username
FROM profile INNER JOIN
登录ON profile.log_id = login.log_id
WHERE（profile.name1 LIKE @ name1）或
（profile.mob_no LIKE @mob_no）或
（个人资料。 emailid LIKE @emailid ）或者
（login.username LIKE @username）
然后它适用于名称文本框。当我写查询时
SET @ name1 =''％'' @ name1 ''％''
SET @mob_no =''％'' @mob_no ''％''
SET @emailid =''％'' @emailid ''％''
SET @username =''％'' @username ''％' '
SELECT profile.name1 AS name，profile.address，profile.mob_no，profile.emailid，login.username
FROM profile INNER加入
登录ON profile.log_id = login.log_id
WHERE（profile.name1 LIKE @ name1）或
（profile.mob_no LIKE @ mob_no）或
（profile.emailid LIKE @emailid）或
（login.username LIKE @username）
然后它不起作用任何文本框。
I have written this query in storeprocedure.But using this I can only search data with complete text.For Example:I can search data whose name=''ronak''.i can not search data whose name start with ''r''.
please help me how to do this.
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE (profile.name1 LIKE @name1) OR
(profile.mob_no LIKE @mob_no) OR
(profile.emailid LIKE @emailid) OR
(login.username LIKE @username)
I have try below 2 solution ,but when I write query
SET @name1 = ''%'' @name1 ''%''
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE (profile.name1 LIKE @name1) OR
(profile.mob_no LIKE @mob_no) OR
(profile.emailid LIKE @emailid) OR
(login.username LIKE @username)
then it is working for name textbox.And when I write query
SET @name1 = ''%'' @name1 ''%''
SET @mob_no = ''%'' @mob_no ''%''
SET @emailid = ''%'' @emailid ''%''
SET @username = ''%'' @username ''%''
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE (profile.name1 LIKE @name1) OR
(profile.mob_no LIKE @mob_no) OR
(profile.emailid LIKE @emailid) OR
(login.username LIKE @username)
then it is not working for any textbox.
正确答案
尝试：
Try:
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE
(profile.name1 LIKE @name1 '%') OR
(profile.mob_no LIKE @mob_no '%') OR
(profile.emailid LIKE @emailid '%') OR
(login.username LIKE @username '%')如果你想搜索值中的任何包含，那么你只需要用''％''字符包装你的参数。
If you want to search for any inclusion in a value then you just need to wrap your argument with ''%'' characters.
SET @name1 = '%' @name1 '%'
SET @mob_no = '%' @mob_no '%'
SET @emailid = '%' @emailid '%'
SET @username = '%' @username '%'
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE profile.name1 LIKE @name1
OR profile.mob_no LIKE @mob_no
OR profile.emailid LIKE @emailid
OR login.username LIKE @username这篇好文章是转载于：学新通技术网
