Mysql LIKE clause problem

[stalkerism]

 
PreparedStatement s = con.prepareStatement(query);
String query = "SELECT * FROM customers WHERE cust_id = ? OR cust_ic = ? OR cust_name LIKE '%'?'%'";

This query does not work. How does i use the LIKE clause with the % together in preparedstatement?

It does not return me any value even the value is there in the DB

HELP PLS!!!

[stalkerism]

found solution.... :p

String query = "SELECT * FROM customers WHERE cust_id = ? OR cust_ic = ? OR cust_name LIKE ?";
            PreparedStatement s = con.prepareStatement(query);
            s.setString(1, id);
            s.setString(2, ic);
            s.setString(3, "%"+name+"%");

the % must be add in when setString.