MySQL Forums :: Java :: unable to get the data using concat method

hi,
in my application.. i'll enter values in text field i.e., "app1,app2,app3" for that what i mentioned is my query.From that text field im getting the values into query..can you suggest me how to write the query.here is my query..but not getting the values.
select
contenttag8_.contentid ,cmstags9_.tagname
from
cms.content_tags contenttag8_,
cms.cms_tags cmstags9_
where
cmstags9_.tagid=contenttag8_.tag_id
and (
cmstags9_.tagname like concat(concat('%app1%','%app2%'))
)