ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: LIKE and Wildcards
Date Thu, 14 Apr 2005 01:01:06 GMT
you could either make that part of your input or you could use
something to the effect of
SELECT
           *
       FROM device,person
       where device.owner = person.regid
       <isNotEmpty prepend="AND" property="description">
       description like '%' || #description# || '%'

Brandon


.

On 4/13/05, Nic Werner <werner@sonoma.edu> wrote:
> Hi again,
>     Is there a way to use the 'like' operator and also use wildcards?
> I'm trying to use Oracle with this, and the following does not work:
> 
> SELECT
>             *
>         FROM device,person
>         where device.owner = person.regid
>         <isNotEmpty prepend="AND" property="description">
>         description like %#description#%
> 
> (I get invalid symbol)
> 
> All examples only use the equivalent of #description# which doesn't add
> anything of value, it is the equivalent of using '='.
>

Mime
View raw message