根据条件搜索记录 [英] Searching Records based on Condition

问题描述

我有一个表，在该表中有10列.我必须根据列名-关键字，城市和经验来搜索记录.为此，我必须编写存储过程.我想要这样的结果.

如果用户首先输入诸如"Java项目管理器"之类的关键字，则该"Java"和项目管理器"之后的所有与"Java项目管理器"相匹配的数据.请帮助我...

I have a table, in that table their is 10 columns. I have to search records based on column name-Keywords,City and Experience. To do this task I have to write store procedure. I want result as like this..

If user enter Keywords such as "Java project manager" first all data matching to "Java project manager" after that "Java" and "Project Manager".Please help me...

推荐答案

使用子字符串& CharIndex 函数，用于将"Java项目管理器"拆分为"Java"& "项目经理"，
在单词&中找到第一个空格然后使用子字符串.
例如.

use substring & CharIndex function for split ''Java project manager'' to ''Java'' & ''Project Manager'',
find out first space in word & then use substring.
eg.

select substring('Java Project Manager',0,CHARINDEX(' ', 'Java Project Manager'))

select substring('Java Project Manager',CHARINDEX(' ', 'Java Project Manager')+1,len('Java Project Manager')-CHARINDEX(' ', 'Java Project Manager'))

然后写两个查询

then write two Queries

select * from tbl where fld like '%Java%'
union all
select * from tbl where fld like '%project manager%'

或

or

select * from tbl where fld like '%Java%' or fld like '%project manager%'

祝您编码愉快！
:)

Happy Coding!
:)

使用全文
http://msdn.microsoft.com/en-us/library/ms142571.aspx [ ^ ]

use full text
http://msdn.microsoft.com/en-us/library/ms142571.aspx[^]

这篇关于根据条件搜索记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！