>Hi All
>I have developed a recruitment Software,where in Resumes are entered and searched as per the job criteria.
>There is a field in Applicant Table called Languages which holds the languages known by applicant.
>Example
>Applicant Id, Languages
>1, English,French,Chinese
>2, Spanish,English,French
>3, French,English,Russian
>4, German,Latin,French,Russian
>5, Hebrew,Arabic
>6, Chinese,English
>
>
>Now lets say I have the above records in my table and i want to search for Applicants who know English & French
>So my query result must be
>
>Applicant Id
>1
>2
>3
>
>Can you'll suggest what can be the SQL statement for this result set.
>
>Thanx
On top of my head:
SELECT * FROM MyTable
WHERE Languages LIKE '%English%' AND
Languages LIKE '%French%'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.