1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Extracting E-Mails From DB?

Discussion in 'Databases' started by Daniel B, Mar 13, 2011.

0
  1. #1
    I have a large amount of usertables that I extracted from my forum databases. I'm looking to extract all the emails from these databases as there are over 20k, what is the easiest way of doing this?

    Also, does anyone know an efficient mass mailer for advertising?
     
    Daniel B, Mar 13, 2011 IP
  2. chrisceo

    chrisceo Peon

    Messages:
    107
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If these emails do not have unsubscribe or were opt-in, you are in violation of the CAN-SPAM laws and will be charged $1 per message if you were brought to court for civil fines.
     
    chrisceo, Mar 13, 2011 IP
  3. nittin123goel

    nittin123goel Peon

    Messages:
    70
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    i can exract them for u for a nominal fee. PM me if interested.
     
    nittin123goel, Mar 17, 2011 IP
  4. SSC

    SSC Active Member

    Messages:
    995
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    80
    #4
    You can easily extract them by issuing a simple SQL query:

    You need to edit the query to make sure you have proper entries for user tables and email column

    Hope this helps
     
    SSC, Mar 17, 2011 IP
  5. StevenF50

    StevenF50 Greenhorn

    Messages:
    67
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    20
    #5
    Thanks for this, I don't agree with spamming though.
     
    StevenF50, Mar 20, 2011 IP
  6. peoplesinnovation1

    peoplesinnovation1 Greenhorn

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #6
    By SQL query.
     
    peoplesinnovation1, Mar 30, 2012 IP