I am working a database search by supplying a 'memberName'. There is a field in the data table called 'message_receiver'. I want to count the number if the 'memberName' and the 'messag_receiver' is a match and return the number. How do I do it?
Hi JiaPei Jen , It seems you need count of the result set returns from the query according to the parameter passed. Try the following query: String query = "SELECT count(*****) as countNo FROM message_thread WHERE message_receiver = '" + memberName + "'"; or String query = "SELECT count(*****) as countNo FROM message_thread WHERE message_receiver like '%" + memberName + "%'"; Then usinf your resultset retrieve the first element as String noOfMembers=rs.getString("countNo") Hope it will hepl you. Mukesh