Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
From: "Sven.Boden" <list123@pandora.be>
To: user-java@ibatis.apache.org
Importance: Normal
Sensitivity: Normal
Message-ID: <W997092003136131140099921@nocme1bl6.telenet-ops.be>
Date: Thu, 16 Feb 2006 14:25:21 +0000
Subject: Re:  Using percentages with like and parameter
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit


Should also work:

select * from table where label like '%' || #keyword# || '%'

Regards,
Sven


>----- Oorspronkelijk bericht -----
>Van: Jared Blitzstein [mailto:mailing-list@blitzstein.net]
>Verzonden: donderdag, februari 16, 2006 03:08 PM
>Aan: user-java@ibatis.apache.org
>Onderwerp: Re: Using percentages with like and parameter
>
>The way I've done it is actually set the %'s when you setup  
>#keyword#. So myObject.setKeyword("%myliketerm%");
>
>On Feb 16, 2006, at 8:42 AM, Hilde.DE-GRAEVE@ext.cec.eu.int wrote:
>
>>
>>
>> Hello,
>>
>> I have the following select :
>>
>> Select * from table where label like  #keyword#
>>
>> Does anyone know how to add the % percentages before and after the  
>> keyword.
>>
>> I tried it before and after but ibatis does not accept it.
>> So I'm doing it in my class that calls the query but would like to  
>> know if there is another solution.
>>
>> Thanks,
>>
>> Hilde
>>
>>
>>
>
>