Query using Explode Function

[tor_gg]

Hiya

I have been given a table with 6 fields.

 

ID (index)

gRef (string of ID numbers  1, 14, 287    etc)

bRef (single ID number)

gName (Name relating to gRef)

bName (Name relating to bRef)

pages

 

I have to produce 2 views

1. (done) pass the ID variable to the page and return results where bRef = ID

 

2. pass the ID variable to the page and return results where each gRef = ID

 

I have seen examples on how to split up a string based on the comma's etc but none on how to apply this to the query. 

 

Cheers.