This has always puzzled me.
Let's say I have a social network where people can add each other as FAVORITES.
How would I store those Favorites, in its own Table where all the favorites from all the users are stored, or in its own Field for that particular user?
If the Favorites are in their own Table, then to show a user who their Favorites are, I have to do a query to get all the rows where the "from" key matches the current user.
If the Favorites are stored in a comma-separated text field in each user's profile, then to show a user who their Favorites are, I have to just pull that field and explode the comma-separated values to display each Favorited user.
Which method is better? Any other, more-efficient methods?
Thanks for your help!