http://www.perlmonks.org?node_id=1064277


in reply to Storing multiple value field in a MySQL database

Wrong solution; If you have a field that needs to hold more than one value, that field usually deserves a new table:

Table1: userid email age john john@example.com 45 jerry jerry@example.com 22 Table2: userid memberof john admins john wizzards jerry newbies jerry trainees jerry newhires

Dave