Mysql field modification

[selenin]

Hello, I'm just trying to modify a mysql field named source_id smallint(2), now I want to make it for more ids then one.

I thought to do it like source_id varchar(100) and then write the ids like 53 ¦ 34 ¦ 78 ¦ and so on. Do you think that's a

good idea, I'm pretty new with mysql?

[Mchl]

It's a bad idea. If there will be more than one source_id assigned to a record in this table, you should move this data to other table.

[selenin]

Thanks Mchl