I have a
varchar(255) field in one of my
Jdatabase tables containing values separated by commas. Precisely, it contains numbers separated by commas.
I want to retrieve the individual values using a custom PHP module. Actually, I need to select records (retrieve data) from another table which have an id that exists in the comma-separated list of ids.
What would be the best way to achieve this?