MySQL Row Multiple Values?

[NSA]

(I kinda feel like I'm filling this section up because I'm such a noob)

Hey guys,

I was wondering... How could I create a column in a row with multiple values.
For instance, I have a column called "connected_users".
I use this row to see who a certain person is friends with.
Say "Bob" was friends with "James" & "Sally".
How could I put two values into "connected_users"?
Would I do it like: "Connected_Users: 'James', 'Sally'"
Or: "Connected_Users: James & Sally"?
Or: "Connected_Users: 'James' & 'Sally'"?

Really need help with this
Cheers.

 

[Benden]

Why not just put a row called connected in the users table?
1 for yes
0 for no

You'd get the same result?

 

[NSA]

So then I'd have to have a column for each user?
Like saying: Is he connected to James? No (0)
Is he connected to Anna? Yes (1)

But then I'm not sure how I'd structure it.

 

[ButtLord420]

You could do this:

Friendship: 1 is friends with 32.

then give every user an ID

 

[NSA]

But what I'm trying to say is, what if person 1 was friends with person 32 AND 33?

 

[Ecko]

The way you structured it is incorrect. connected_users would be better off being in its own table than in a column for an existing table. Although it would help if we could see the actual database structure and what your end goal is.