How to relationship when id value has comma #236
Description
I have two tables, categories and movies.
In movies table I have a column categories. That column consists of the categories that movie fits in. The categories are IDs separated by a comma.
`Table categories {
-id- -name-
1 Action
2 Comedy
4 Drama
5 Dance
}
Table movies {
-id- -categories- (and some more columns ofc)
1 2,4
2 1,4
4 3,5
}`
how i can i get categories in movies table showing name: $movies_module->categories
Thank you,
Sorry for the misspeled