Return-Path: 
 <user-java-return-3064-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 92849 invoked from network); 29 Jun 2005 20:33:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 29 Jun 2005 20:33:43 -0000
Received: (qmail 39747 invoked by uid 500); 29 Jun 2005 20:33:41 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 39726 invoked by uid 500); 29 Jun 2005 20:33:41 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 39712 invoked by uid 99); 29 Jun 2005 20:33:41 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 13:33:41 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.192 as permitted sender)
Received: from [64.233.162.192] (HELO zproxy.gmail.com) (64.233.162.192)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 13:33:43 -0700
Received: by zproxy.gmail.com with SMTP id l8so524197nzf
        for <user-java@ibatis.apache.org>;
 Wed, 29 Jun 2005 13:33:40 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=BHX2iTKIm9snez7BeD3/t2TvMMlz0KMvy/KF4u2veegEsH2mYNsr3iSQEUjKg8M0PyRlA5dCwRLLy9inG2IJPSmwLsfcJDl8f/pNZcyogYyAcSMZk81x76cxaebq+vVVDu6DD7Y3LseZsyQQvkd2WnupaN7HptNPF96Eva9koAI=
Received: by 10.36.120.13 with SMTP id s13mr6039140nzc;
        Wed, 29 Jun 2005 13:33:39 -0700 (PDT)
Received: by 10.36.90.14 with HTTP; Wed, 29 Jun 2005 13:33:39 -0700 (PDT)
Message-ID: <a10a823c0506291333379b4dc8@mail.gmail.com>
Date: Wed, 29 Jun 2005 14:33:39 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: Using LIKE clause in SqlMap
In-Reply-To: 
 <2352A440BDEB4E45A8E96E277F2376570152235A@MSGMMKCLB2WIN.DMN1.FMR.COM>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <2352A440BDEB4E45A8E96E277F2376570152235A@MSGMMKCLB2WIN.DMN1.FMR.COM>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+=
LIKE+in+my+queries%3F

On 6/29/05, Rao, Satish <satish.rao@fmr.com> wrote:
> =20
>=20
> I have the following entry in my sqlmap:=20
>=20
>         <select id=3D"listUsersByFilter" parameterClass=3D"com.classname"
> resultMap=3D"list-users-result" cacheModel=3D"user-cache">=20
>=20
>             SELECT=20
>                 UID,=20
>                 AGE,=20
>                 FIRSTNAME,=20
>                 LASTNAME=20
>             FROM=20
>                 USERS=20
>                 <dynamic prepend=3D"WHERE">=20
>                 <isNotNull prepend=3D"AND" property=3D"lastName">=20
>                         LASTNAME LIKE #lastName#=20
>                 </isNotNull>=20
>                 <isGreaterThan prepend=3D"AND" property=3D"age"
> compareValue=3D"0">=20
>                         AGE =3D #age#=20
>                 </isGreaterThan>=20
>                 </dynamic>=20
>         </select>=20
>=20
> How do I wrap #lastName# with '%'?=20
> =20
> =20
> =20
> =20
>