Hi Andy,

we have a same kind of statement in our xml file and it looks like this:

<codesnippet>
<mapped-statement name="statementName" result-map="result">
 SELECT * FROM tbl_name WHERE column_name LIKE '%';
</mapped-statement>
</codesnippet>

Pay attention to the single quotes around the %-sign!

Good luck!

Cheers,

Ronald

----- Original Message ----- 
From: "Andy Engle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 26, 2004 7:47 PM
Subject: [OT] "SELECT ... LIKE" with iBatis


> Hi all,
> 
> I am trying to write a "SELECT ... LIKE %whatever%" statement with
> iBatis but I can't seem to get it to work, nor can I find a clear
> explanation of how to do this.  Does anybody have a code snippet they
> could share with me of how to do this?
> 
> Thanks in advance.
> 
> 
> Andy
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to