CiviCRM Community Forums (archive)

we have data in mysql.
My question is related to exporting certain data in to this format "Interest one, Interest Two, Interest Three"
This way during the civi import it will see this Interests column as ONE column with multiple interest.  This then will populate my custom multi select field in civi for that contact with multi choices.
For example
First, last, interests
John, Smith, "Politics, Energy"
Then after the import he will have both chosen in the menu under "Interests".
Right now it works when I import the above example that I hand write out in a csv file. 
What I need is the mysql query to export from the database so instead of giving me a list like this
John, Smith, Politics
John, Smith, Energy
Which overwrites the first one (even as "Update" or "fill" it overwrites the first import on the multi select)
To create an export that says for every John Smith give me his interests in this format.
John, Smith, "Politics, Energy" <--this export would make the import good

Thanks
Alfred

thanks I will give it a try