How to set up a select map

[Ra...@emc.com]

Hi, 
I want to do a pattern matching search on the database; for e.g select all
rows that have text "ab" in them. The text can occur independantly or
embedded. How do I do a pattern matching Select with the IBATIS map?
Thanks,

Mithra Rajah 

Re: How to set up a select map

[Larry Meadors <lm...@apache.org>]

Three ways:

1) Use "where value like #property# and put the pattern in your property.

2) Use "where value like '%' || #property# || '%'and put the value in your
property.

3) Use "where value like '%$property$%" and put the value in your property.

The last option will open you you up to SQL injection, and is generally bad
practice. It also does not take advantage of some database vendors'
execution plan caching.

Larry


On 10/26/05, Rajah_Mithra@emc.com <Ra...@emc.com> wrote:
>
> Hi,
> I want to do a pattern matching search on the database; for e.g select all
> rows that have text "ab" in them. The text can occur independantly or
> embedded. How do I do a pattern matching Select with the IBATIS map?
> Thanks,
>
> Mithra Rajah
>