Re: like issue plz help me

[Anoop kumar V <an...@gmail.com>]

Exactly my point - 2 different sql queries will output 2 different
sets of results

On 9/23/09, Dan Turkenkopf <dt...@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....@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
>
>


-- 

Thanks,
Anoop

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