This is similar to a problem I faced yesterday. I have a table
"property_facilities" which is essentially a table listing facilities
available at different properties. The table structure looks something like:
property_id facility_id
--- ---
01 01
01
Use SET column type if you want. But there is a limit for how many
members can the SET type have (64 in MySQL).
I would go with the first approach.
Kae Verens wrote:
this will return true for something like 'pool|fireplace|fitness'
mysql_query('select id from theTable where amenities like "%pool
2 matches
Mail list logo
