Storing an array of strings in mysql and using the IN() function on it

[farzher]

So, I want to be able to do this: "WHERE something IN(SELECT array FROM table WHERE id='$id')"

So that I can select the array of strings and use the IN function on it.

 

Is this possible? Right now I have to select the CSV array of strings ex: "one,two,three" and format it like this "'one','two','three'" using php then do a second select passing that sting into the IN function.

 

What kind of format would I need to use to get this to work in one query with mysql?

[JonnoTheDev]

Yes this is possible if you cannot do it with regular joins. ie

 

SELECT name FROM users WHERE id IN(SELECT id FROM logins)