# \[mysql\] friends list

**URL:** <https://forum.kirupa.com/t/mysql-friends-list/253440>\
**Category:** programming\
**Created:** [March 1, 2008, 5:30am UTC](https://forum.kirupa.com/t/mysql-friends-list/253440 "2008-03-01T05:30:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kingofnukes](https://avatars.discourse-cdn.com/v4/letter/k/9d8465/32.png) [@kingofnukes](https://forum.kirupa.com/u/kingofnukes)\
**Post date:** [March 1, 2008, 5:30am UTC](https://forum.kirupa.com/t/mysql-friends-list/253440/1 "2008-03-01T05:30:06Z")

</div>

what is the best way to set up a way for a user to have a friends list in mysql?

All i can think of is either having a user have a single column with all the friends in a string within it.