Posted on: 03/13/06 04:21am
By: Anonymous (streamer)
hello,
I find out that the Mail Utility within Geeklog is really slow when I send out mass emails to all users, thus I would like to export all email adresses from the whole user database. How can I do this? Is there any SQL command that reads out all adresses?
thank you for your help
export email adress
Posted on: 03/13/06 04:36am
By: kr
Hi streamer,
getting all email addresses out of the database is really simple...
Just try this sql statement:
SELECT email FROM `gl_users` WHERE email != 'NULL';
export email adress
Posted on: 03/13/06 04:53am
By: Anonymous (streamer)
perfect! thx for your fast help, kr!!
export email adress
Posted on: 03/13/06 07:45am
By: 1000ideen
On the other hand it would be nice to understand IF and why geeklog is slow and what could be done against that.
export email adress
Posted on: 03/13/06 02:21pm
By: beewee
Especially Geeklog.net, which is awfully slow the last months..
export email adress
Posted on: 03/13/06 02:52pm
By: Dirk
[QUOTE BY= streamer] I would like to export all email adresses from the whole user database.[/QUOTE]
phpMyAdmin can also export to CSV format, which may come in handy here.
bye, Dirk