Ask:
May I know how mybatis deal with like '%specific_string%' please?
like #{string} does not get my result, what I really need is like
#{%string%}
Question:
You have three options
'%'||${specific_string}||'%'
or
#{do_it_in_java}
or
someFunctionOrProc(#{specific_string}) where the function/proc will
handle it. If you use this a lot in multiple SqlMaps then I might go
down this road.