I might be missing your question, but... Your ibatis query is wildcarded on both sides versus your straight SQL one. Try removing the first %.
On Wednesday, September 23, 2009, quinya <y.qui...@ilocal.nl> wrote: > > Not sure if I understand right but can't you just do... > > select * from Someone where UPPER(name) like UPPER(#name# ) > > Then put the '%' in the actual name proerty value. As in String s = > "%nameParamValue%"; > > That's how I do my LIKE statements. > > > > HelpMePlz wrote: >> >> Hi to all, >> >> select * from Someone where name like 'a%' >> this is in oracel >> >> if i run this query i am getting only 3 records >> >> for this query in ibatis >> >> Select * from someone where UPPER(NAME) LIKE '%' || >> UPPER(#name#)||'%' >> >> if i run this query i am getting all the results which name contain 'a ' >> in that like i am getting 10 results but i have to get only 3 results >> which name strating with 'a' >> >> >> please can any one help me it is very urgent for me >> >> i tried like this also which is qiven in FAQ in Ibatis >> >> >> Select * from someone where UPPER(NAME) LIKE '%%' || >> UPPER(#name#)||'%%' >> http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+LIKE+in+my+queries >> >> ' >> >> >> >> > > -- > View this message in context: > http://www.nabble.com/like-issue-plz-help-me-tp25531101p25531117.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
