ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Turkenkopf <dturk...@gmail.com>
Subject Re: like issue plz help me
Date Wed, 23 Sep 2009 12:57:39 GMT
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.quinby@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message