[SOLVED] Retrieve data comma delimited field

Hello, I need some help to search through a DB field that has multiple values that are separated by ’:’ .

An example of the data is option1:option2:option3 and I would like to be able to click a link like this?value=option2 and for all records with the options2 data be displayed. I’m unsure of how to do a search like that if someone could give me some pointers.

I would like to fine out how to do this mainly for REV. I would normalise the data but I have no choice but to use a delimited list for now.

Thanks.

I’ve figured this one out.