unable to execute "like" query in java

Question

In MYSQL database I have a table name search. When I write this query it executed successfully.

"select * from 'search' where path like %overview%"

But when I write it in java:

String query="SELECT path FROM `search` WHERE path like %?% ";
java.sql.PreparedStatement st=con.prepareStatement(query);
st.setString(1,textField.getText() );
ResultSet rs=st.executeQuery();

It's not working and displays an error:

com.mysql.jdbc.exception.jdbc4.MySQLSystaxErrorException: you have an error in sql syntax; check the manual that corresponds to your Mysql server version for the right Syntax to use near '%'overview'%' at line 1

What error? And why the grave accents instead of single quotes? — Mena
– Mena, Commented Apr 30, 2015 at 13:09
i dont have 10 reputation so i cant add picture with that so i need to write that error: — Rakibul Hasan
– Rakibul Hasan, Commented Apr 30, 2015 at 13:12
stackoverflow.com/questions/8247970/… this link will be useful — Vigneshwaran
– Vigneshwaran, Commented Apr 30, 2015 at 13:14
the error is: com.mysql.jdbc.exception.jdbc4.MySQLSystaxErrorException: you have an error in sql syntax; check the manual that corresponds to your Mysql server version for the right Syntax to use near '%'overview'%' at line 1. — Rakibul Hasan
– Rakibul Hasan, Commented Apr 30, 2015 at 13:15

MrTux · Accepted Answer · 2015-04-30 13:18:51Z

4

String query="SELECT path FROM `search` WHERE path like ? ";
java.sql.PreparedStatement st=con.prepareStatement(query);
st.setString(1,"%"+ textField.getText() + "%" );
ResultSet rs=st.executeQuery();

You can try the above code

edited Apr 30, 2015 at 13:18

MrTux

34.4k30 gold badges120 silver badges158 bronze badges

answered Apr 30, 2015 at 13:17

Vigneshwaran

3971 gold badge2 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

spencer7593 · Accepted Answer · 2015-04-30 13:59:20Z

0

The percent signs are literals, if you want to include those in the SQL text, and have MySQL add those to the value you pass in, you could do something like this:

String query="SELECT path FROM `search` WHERE path LIKE CONCAT('%',?,'%')";

The other alternative is to remove the percent signs from the SQL text statement

String query="SELECT path FROM `search` WHERE path LIKE ?";

and then prepend/append percent characters to the value you supply.

answered Apr 30, 2015 at 13:59

spencer7593

109k15 gold badges122 silver badges148 bronze badges

Collectives™ on Stack Overflow

unable to execute "like" query in java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related