ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Select Query 'LIKE' Issue
Date Thu, 15 Oct 2009 14:33:52 GMT
I personally prefer to add the wildcards in the Java code.  But
concatenation in the SQL works as well.
Clinton

On Thu, Oct 15, 2009 at 6:31 AM, Ingmar Lötzsch <
iloetzsch@asci-systemhaus.de> wrote:

> If || is the operator for string concatenation, try
>
> like '$pattern$' || '%'
>
> respectively
>
> like '%' || '$pattern$' || '%'
>
> gonas schrieb:
> > Hello ,
> >
> > I am using Ibatis 2.3.Issue Persist as Below mentioned.
> >
> > Query in Respective Configuration XML As:
> >
> > <select id="getSerialNumber" resultClass="java.lang.String">
> >       select ifnull(max(account_number),0) from account_details where
> > account_number like '$pattern$%'
> > </select>
> >
> > TRIED PATTERS : $pattern$% , %$pattern$%
> > So Here SQL always retuning Non Zero Value.If suppose In DB '99970' such
> > data exist ,where i am trying to search for '99980' then also i am
> getting
> > Non Zero Values.Ideally in this case DB Should return zero according to
> > query.
> >
> > If any one of you understand the scenario please notify me any thing
> wrong
> > in this.
> > CONFIGURATION :: OK.
> >
> > Thanks in Advance,
> > Suman
>
>
> ---------------------------------------------------------------------
> 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