title: MySQL table inside table
body: <p>I'm wondering what is the right way to store the following data inside an MySQL DB.</p>
  
  <p>Let's say an object for example a video. and I want to store the the rating which was give to it by other user, so on option is create a column and store the ID of the users and their rating in a complex way, like that:</p>
  
  <pre><code>| ID | video_name | rating (usrID,rating)    |
  | 5  | cool video | (158,4),(5875,1),(585,5) |
  </code></pre>
  
  <p>I guess that it is not the most efficient way to do so.
  Is there a way to store a table inside of a row? what is the most efficient way to do it so I can use SQL query on the rating without processing the data via a PHP code?</p>