how to use wild cards in search engine to search

Dear every one,

how to search particular data in database using AND operator...

i have used LIKE operator to search and am able to retrieve datas....

but the problem is how to search the datas using AND operator...

eg: if i am searching for employees based on skills..ie java and jsp

how to get only those employees...

the code that i used for LIKE operator is..

pr=con.prepareStatement("select eid from lang where language like ? ");

pr.setString(1, "%" + s2 + "%")

[523 byte] By [senthil_yogaa] at [2007-11-27 5:56:29]
# 1
Free text search is not something SQL is particularly good at - there exist proprietary extensions for some databases, but obviously that's not a portable solution. You might want to check out Lucene: http://lucene.apache.org/java/docs/
dcmintera at 2007-7-12 16:27:16 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
This is an ordinary crosspost: http://forum.java.sun.com/thread.jspa?threadID=5178151He already has the answer: [url= http://www.google.com/search?q=sql+tutorial]learn SQL[/url].
BalusCa at 2007-7-12 16:27:16 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...