ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nic Werner <wer...@sonoma.edu>
Subject LIKE and Wildcards
Date Thu, 14 Apr 2005 00:56:54 GMT
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