i tried what u suggested me

select

contenttag8_.contentid ,cmstags9_.tagname

...

i tried in google...all the examples are given as use of concat in "select" statement..but i need to implement in "like" statement...

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...

no..im using mysql..can u help me out..

hi,

i had done the query like this SELECT ct.tagname,B.contentid

FROM tags ct

JOIN (SELECT DISTINCT tagid FROM tags ) tbl ON ct.tagid = tbl.tagid

INNER JOIN ct_tags B ON ct.tagid =...

hi,

i used where clause..here it is my query

select DISTINCT

ct.tagname,cot.contentid

from tags ct

inner join ct_tags cot

on ct.tagid=cot.tag_id

...

hi,

thanks for the replies...i tried what Steve Jones had given...i m getting all the data but i need is to get for particular id i need the...