How to join a table.id on a serialized table field???

[eluser]123wesweat[/eluser]
Hi,

Storing multiple colors with checkboxes and store the colors as serialize data and unserialize to repopulate the form checkboxes.

For this, i have a tableA with colorID and colorName

In tableB i store a serialized array with multiple colorID's in field colors.

How do return the colorName with on query??

Code:

Select tableA.colorID as colorID, tableA.colorName as colorName FROM tableA JOIN ....

Hope you understand my question