Re: [OT] "SELECT ... LIKE" with iBatis

2004年3月26日 11:43:40 -0800

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