how can i build a query select ... like
with :

select x,y, from y,z,
where w like '%y%' ?????????

I want the y to be the value and not a single string or character!!!
For example if all the y's are values like names : "Peter,John,Bob,..." to find the w ' s that contain the name :"Peter,John,Bob,..." and not the y character or the &y or the $y e.t.c.Is there a way to do that ???

Anyone idea???

if you are using the like clause then I suppose
where forename like name1 or foremame like name2

also where forename in (name1,name2,name3)

Yes sure,but what if i have 500 names??(in my case unfortunatelly i have)...

WHERE w LIKE CONCAT('%', y, '%')

--
felix

Thanx a lot ! I have tried this without concat somehow and it didnt work!