WordPress.org

Ready to get started?Download WordPress

Forums

MySQL query problem (1 post)

  1. ginntonic
    Member
    Posted 4 years ago #

    Here's my dilemma:

    I'm running a custom install script, borrowed heavily from WP's, that dumps the extra fields into the wp_usermeta table, e.g. whether they want to receive the newsletter.

    So, when I go to get their information in csv to import into pommo (which rocks, by the way!), I want to use a query like this one, but can't phrase it properly, and phpmyadmin is so much of a dinosaur, I don't want to peruse the database for hours collecting the information by hand.

    This is what I have so far:

    SELECT user_id FROM wp_usermeta WHERE meta_key = "newsletter";
    --- this top part works fine. I know the next part is completely ridiculous in how wrong it is, but I can't phrase it properly.---

    FOR EACH user_id[which I just got] SELECT user_email

    ---this next part also is fine---
    INTO OUTFILE '/path/to/file/email_list.csv'
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    FROM wp_users;

    Any help would be greatly appreciated!!

Topic Closed

This topic has been closed to new replies.

About this Topic