user3808307 user3808307 - 1 year ago 89
MySQL Question

How to do a MySQL query with these relational tables

I have the following tables


id | title | url


video_id | category_id

I would like a query to get once all videos from the video table that have a certain category_id

Answer Source
SELECT * FROM videos v, video_to_category vc
WHERE AND category_id=YOURID