how i emanate mysql join query wholly selecting rows list where certain array references quarrel exist another table?
i have twin tables database, called ratings movies.
ratings:
| id | movie_id | rating |
movies:
| id | due |
a customary film record competence this:
| 4 | cloverfield (2008) |
and there competence several rating annals cloverfield, this:
| 21 | 4 | 3 |
(rating array 21, film array 4, giving rating 3)
| 22 | 4 | 2 |
(rating array 22, film array 4, giving rating 2)
| 23 | 4 | 5 |
(rating array 23k film array 4, giving rating 5)
the question:
how i emanate join query wholly selecting rows film list have some-more x
array ratings ratings table? example, above instance cloverfield wholly rating ratings list x
2, selected.
thanks any assistance advice!
Comments
Post a Comment