SQL: Export Comments by Author?

  • fireundubh

    (@fireundubh)


    15 years, 6 months ago

    What is the SQL code for exporting all comments from database by author’s name or e-mail address? Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter fireundubh

    (@fireundubh)

    15 years, 6 months ago

    Bump.

    whooami

    (@whooami)

    15 years, 6 months ago

    search got you down?

    honestly, why not fire up phpmyadmin and do a little tinkering?????

    SELECT * FROM my_comments where comment_author_email = ‘name@email.com’;

    the above is from the cli so ive removed the backticks that are usually needed in phpmyadmin — the forum mangles them here anyway.

    look at the name of the various fields inside your comments table for what to use in the case of the the comment author’s name.

    whooami

    (@whooami)

    15 years, 6 months ago

    oh, i shouold add too, that if youre using phpmyadmin, after running thyat query, you would just click the export button.

    Thread Starter fireundubh

    (@fireundubh)

    15 years, 6 months ago

    Thanks. I’ll try this out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL: Export Comments by Author?’ is closed to new replies.