SQL column with multiple values
<p>i want to know how can we store multiple values in a sql column, or which is the best way to store the values in a sql column.<br>
<br>
Consider in a movie table, a movie will be having multiple Genre<br>
eg,<br>
Genre: "Action, Adventure, Fantasy"<br>
Genre: "Adventure, Drama, Fantasy, Thriller"<br>
<br>
which is the best way to store the Genre values in database.</p>