help getting data from db table

I thougth this might be worth a shot.

Ok, well i thought about emailing all my old users that where in my old forum i could never get to import. So they could know about the new forum etc.
Is there some sort of sql comand where i can get it to out put 1 field in a db table with maybe a comma between them. Just a list of all the email address in my db?

Its an mysql db. I have the tables sql file dl but i dont' want to copy paste 400 emails addys.

Do you still have the old database ?
If yes the following way shall help you. Download and install xampp to your computer and install your old forums software to your pc. Then dump the database over the existing one. There you can import the e-mails pretty easy.

You can do SELECT emailaddress FROM tablename

That will give you a one-column list. Then you should be able to use a text editor and do a search/replace for a CR and replace it with a comma or semi-colon.

Thanks very much, keith. Worked like a charm. Now lets see how many of my very old users pop there head back in.