PHP MYSQL import excell serialized data
<p>I have a column with serialized data in mysql table.</p>

<p>How to import excell file where I have column like colors where are stored serilized data for checboxes in mysql</p>

<p>and need to import from excel file column </p>

<p>colors  colors  colors
white   yellow  blue  -> serialized into 1 column in mysql</p>

<p>structure of excell file can be different.</p>

<p>thanks</p>

<p>mysql table<br>
id | name  | colors<br>
1  | house | serialized(yelow,blue...)  </p>

<p>excell file<br>
name | color  | color<br>
house| yellow | blue  </p>

<p>I'm not sure if is the right way to handle excell file maybe something like this:</p>

<p>name | color<br>
house| (yellow;blue)</p>
