Gossamer Forum
Home : Products : Gossamer Links : Discussions :

extracting contact e-mail address from my Links SQL database

Quote Reply
extracting contact e-mail address from my Links SQL database
My site allows people to register their site without the need of pre-registration. When someone adds a site i ask for various details inclusing contact e-mail address. Now i have many e-mail addresses entered, is there a quick and easy way to just extract those e-mail addresses?

Initially I used Open directory which of course doesn't have any contact e-mail addresses, so all i want is the new ones that people are now entering.

thanks

Leslie
Quote Reply
Re: [bunder] extracting contact e-mail address from my Links SQL database In reply to
In the SQL monitor:

select field_name from prefix_Links

set field_name to the field -- ie: Email (?)

and prefix to what you set your prifix up as (lsql)


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [bunder] extracting contact e-mail address from my Links SQL database In reply to
If you want to extract to a file you can use MySQLMan's export feature. Just select the email field and export - its very easy to do.