Results 1 to 4 of 4
Dec 30, 2004, 12:19 #1
- Join Date
- Dec 2004
- Little Rock
- 0 Post(s)
- 0 Thread(s)
List from pipe delimited MySQL field
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