select * from t where t.name like 'saroj%'
we pass % at the end or beginning or both
if we had to do the same thing in IBatis using dynamic inputs then we can do following
select * from t where name like #name#||'%'
if we have a list of dynamic inputs then following would work
select * from t
where
name like #name[]#||'%'
this would generate following SQL:
select * from t where name like 'saroj%' or name like 'name1%' or name like 'name2%'
No comments:
Post a Comment