comma seperated list in a column in Mysql

[MDanz]

Is a comma seperated list in a column in Mysql good practice?  or should i just loop the INSERT clause... so each value has it's own row?

[Pikachu2000]

Well, neither really is the best option. Build the query string in a loop, then run the query once. Running a query in a loop should always be avoided when possible.

 

$array = explode( ',', 'one,two,three,four,five');
$values = implode( "' ), ( '", $csv );
$query = "INSERT INTO table (field) VALUES ( '$values' )";
$result = mysql_query($query)
etcetera . . . 

 

echo $query returns: INSERT INTO table (field) VALUES ( 'one' ), ( 'two' ), ( 'three' ), ( 'four' ), ( 'five' )

[The Little Guy]

Is a comma seperated list in a column in Mysql good practice?

 

That is horrible practice. I say one value = one row. You can find data hell of a ton easier than with comma separated values. It also is easier to match two columns from 2+ tables.