Searching based on the Keywords

Question

0.00/5 (No votes)

See more:

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.

Posted 1-Oct-11 2:43am

srinivas vadepally

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2011-10-01T03:15:00

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).

SQL

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

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

devildx2050 · Answer 2 · 2011-10-01T03:32:00

Solution 2

you can "like" statement ...

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

Posted 1-Oct-11 3:32am

devildx2050

Searching based on the Keywords

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Searching based on the Keywords

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us