Arrays in php how to solve the problem?

Question

PHP

Hi friends, help me solve one problem. There is a mysql database and a genre column

As you can see, in one column there are genres separated by vergule.
When I make selections from the database and form a query into arrays, it forms the entire column for one identifier

How to make each genre have its own identifier
Here is the source code:

$query  = "SELECT  *  FROM torrents";
$sql = $db->query($query);		   
$arr  = $db->get_row($sql) 

$genre = $arr['genre'];
print_r(array($genre));

Answer 1

1) Normalize the table
2) Use substring_index, and crutches
3) Do the breakdown already in PHP, after the selection. ( $genre = explode(',', $arr['genre']); )
Choose any of the options.
PS
vergole = comma?

Answer 2

If you just want to split the string then explode()
If you need a normal search by genre, normalize the database, put the genres in a separate linked table.