如何从列表中搜索数据 [英] how to search data from list

问题描述

我在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

这篇关于如何从列表中搜索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！