File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes mySql like,query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "mySql like,query" Watch "mySql like,query" New topic

mySql like,query

natasa jones
Ranch Hand

Joined: Aug 20, 2006
Posts: 45
i would like to know what is the correct syntax for a query which takes as parameter a String and then fetches all the rows which have this String or part of the String!
i use String SQL_Movie_Results="select id from myTable where name like '%"+searchTerm+"%'"; inside my fuction,whose signature is

public List searchByName(String searchTerm)throws Exception.

my problem is that i have tried several different approaches in syntax but i could not put the value of searchTerm betweet always says :
select id from myTable where name like '%null%'".
what is wrong with my query?
please help
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

searchTerm is null. Check your code where you call this method, make sure you are setting the value as you expect.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
It is sorta covered in the JavaRanch Style Guide.
subject: mySql like,query
It's not a secret anymore!