Exactly my point - 2 different sql queries will output 2 different sets of results
On 9/23/09, Dan Turkenkopf <dturk...@gmail.com> wrote: > 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 > > -- Thanks, Anoop --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
