search engine "skill1 and skill2 and ...

[chrlow]

Guys, pls help me to solve this problem.

 In my search engine, i wish to do a search with both skill1 and skill2 fulfilled. I am using "MSQL" db. 

Example:

select * from skills where skill_id= "Java" and skill_id="Php";

1. I don't want the "OR" condition but "AND".
2. Pls make the solution be dynamic and not static. I know the static answer which hard code the search.

Example:
select skill_cde from skills where skill_id="Java";
select * from skills where skill_id="PHP" and skill_cde="1234";

pls give me a full algorithm and detail explaination asap.

Thanks a lot!

[amcgrath]

where skill_id in ('Java','PHP','etc')....

[chrlow]

Perhaps your suggestion is not appropriate. The "In" SQL Operator is using the "OR" condition.

But what i want is (skill1 "and" skill2) must be fulfilled.

[amcgrath]

OK, well how's this for inappropriate: You tell me how one column can be many values at the same time? If you look at your (il)logic, you'll see that you are wrong.

[chrlow]

Well, I already know that one column can not have many values at the same time?

And I am also know my logic is wrong already.
I am asking for a new logic which can give me one column can not have many values at the same time in the sense of table design
or change the query.

What you suggest is out of my question already? What i want is to find a person which can have the skill "PHP" and "JAVA".

You give me the answer a person can have the skill either "PHP" or "JAVA". Because the "IN" sql clause is decoded as "OR" operation.

[amcgrath]

Dude, listen to me: if you search this way:
select * from skill where skill = "this' and skill = 'that' you will not get a row returned. It is as simple as that.

Use in ('this','that')... I don't understand why you are so set against it.