Thursday, 22 August 2013

One query for every number in row

One query for every number in row

If I have a database with a field called items with '1,2,3,7,15,25,64,346'
in it. Is there a function to use the commas as a separator and take each
number and start a new query and get info for that id? Like a foreach but
in sql?
I can see it so clear but cannot put it in words...

No comments:

Post a Comment