根据关键词搜索 [英] Searching based on the Keywords

问题描述

我正在一个工作门户项目上工作，我收到了一个根据关键字搜索工作的任务.

您能告诉我如何通过关键字查找工作清单吗?还有其他有关工作门户网站的标准.

谢谢大家.

Hi ,

I am working on a job portal project,and i received a task on searching jobs based on the keywords.

Could you tell me ,how to find list of jobs by keywords?,and also other kind of criteria for job portals.

Thanking you all.

推荐答案

在数据库上使用以下类型的查询(假定您有一个jobs表，该表的列keyword存储关键字信息).

Use the following type of query on your database ( this assumes you have a jobs table with a column keyword that stores the keyword information).

select * from jobs where keyword like '%somekeyword%'

有关更多信息，请咨询您的项目经理，并向他询问您的项目架构结构.

For more information go to your project manager and ask him about your projects schema structure.

您可以喜欢"声明...

声明@prefix varchar(50)
设置前缀=您的字符串''
从tbl_name中选择*，其中的名称类似@prefix +''％''

you can "like" statement ...

declare @prefix varchar(50)
set prefix=''your string''
select * from tbl_name where name like @prefix+''%''

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