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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members