Click here to Skip to main content
13,254,077 members (61,134 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I have Table like

name| skills   | area |<br />
________________________<br />
ajay| .net,wcf | hyd  <br />
ram   | java,.net| bang

I want to find who have candidates skills like java,dot in stored procedure
can u guide or end any snippets in front my application i am using textbox for for giving input like java,.net
Posted 22-Nov-12 3:54am
Milind_T 22-Nov-12 9:11am
Why are you reposting the question:

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can do it...but it's not easy, particularly if you don't store skills in any particular order. You can use the LIKE condition to pick up one skill:
SELECT name FROM myTable WHERE skills LIKE ''
would pick up both lines, but for multiple skills it's a PITA.

I would change the way you stored skills - have a Skills table, which has a name (".NET", "Java", ...) and an ID, then have a separate table linking the client to a skill (via the client ID). THis way, you can retrieve all those who have multiple skills much, much =more efficiently (And you can't spell "java" as "jova" by mistake when doing data entry and miss some one out for a position)

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171114.1 | Last Updated 22 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100