How to set up a select map

[Rajah_Mithra]

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