arrays in MySQL

[morrisoner]

can i store an array in a MySQL table field. For my little project I have a video table with information about all videos, and I am currently using 5 diff fields for 5 actors. I use integers as actorID's as I have another table for the actors. Is there any way i can set up a field for an array of integers in MySQL. And if I can how do i insert an array into it?????????????
thanks for your help.

[zalath]

I don't see why you should store an array, but if you want to, here's how you store an array into one field (the field should be a [var]char of sufficient length or a text/blob field):

$myarr = array(1,2,3);
$string = implode('|',$myarr);

now store $string into the designated field. Then when you need to fetch the information, you simply:

$myarr = explode('|',$string);

and there you go.

[morrisoner]

thanx for that.
what data type do i make the field? if i make it a text one, can i still compare it to the int actorID field?????