StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19193515
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-05T03:02:11.927
FavoriteCount
0
LastActivityDate
2013-10-05T03:07:23.680
LastEditDate
2013-10-05T03:07:23.680
LastEditorUserId
2449589
OwnerUserId
2449589
ParentId
19192242
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Placing an array of IDs in a single database field isn't really a good idea and you lose some of the power a relational database gives you by designing your database this way. Rather than storing an array of ingredient IDs in your product's table I would create a third table. An example table schema would be like this: <pre> Products id productName productDescription </pre> <pre> Ingredients id ingredientName </pre> <pre> ProductIngredients id id_Products id_Ingredients </pre> Some sample data might look like: <pre> Products id productName productDescription 1 Peanutbutter And Jelly Sandwich Best sandwich ever </pre> <pre> Ingredients id ingredientName 1 Peanutbutter 2 Jelly 3 Special sauce 4 Bread </pre> <pre> ProductIngredients id id_Products id_Ingredients 1 1 1 2 1 2 3 1 4 </pre> You could then get a list of IDs of ingredients containing the word 'nut' like this: <pre><code>SELECT id FROM Ingredients WHERE ingredientName LIKE '%nut%' </code></pre> And a list of products containing ingredients which contain the word 'nuts' like this: <pre><code>SELECT Products.productName FROM Products LEFT JOIN ProductIngredients ON ProductIngredients.id_Products = Products.id LEFT JOIN Ingredients ON Ingredients.id = ProductIngredients.id_Ingredients WHERE Ingredients.ingredientName LIKE '%nut%' </code></pre> You could get a list of ingredients for a product like this: <pre><code>SELECT Ingredients.ingredientName FROM Ingredients LEFT JOIN ProductIngredients ON ProductIngredients.id_Ingredients = Ingredients.id WHERE ProductIngredients.id_Products = 1 </code></pre> This would give you a list such as this: <ul> <li>Peanutbutter</li> <li>Jelly</li> <li>Bread</li> </ul> <h3>Edit</h3> This is is called a many-to-many relationship.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP MySQL select array in array
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USameagher
UserOwnerUserId
1. USameagher
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POPHP MySQL select array in array
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COLooks great ill give it a try thank you for all your effort with this answer!
 singulars
 PostPostId
 PO
 UserUserId
 USuser2848361

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.