Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <25531117.post@talk.nabble.com>
Date: Wed, 23 Sep 2009 05:51:47 -0700 (PDT)
From: quinya <y.quinby@ilocal.nl>
To: user-java@ibatis.apache.org
Subject: Re: like issue plz help me
In-Reply-To: <25531101.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <25531101.post@talk.nabble.com>


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