I am working on a real estate site that has 2 MySQL tables: Features and Listings. The Features table has 2 columns: ID and Description. Each row in Listings has a field that contains a pipe delimited set of numbers (3 | 14 | 26 ...) that correspond to the ID column in the Features table. How do I structure a query to generate a list of Features.Description for each row of the Listings table? In other words, each row in Listings has a set of features grouped together in a single field but identified by ID numbers. How do I print a list of the features descriptions for a particular row?
BTW, data comes in the pipe delimited format from the local MLS... it's not my choice to structure it like that.
I appreciate any help that can be offered... I'm a MySQL newbie