Hello! 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 %%.it always says : select id from myTable where name like '%null%'". what is wrong with my query? please help