Forums

Querying my database for user information (3 posts)

  1. MsCrow
    Member
    Posted 1 year ago #

    Hello

    We run WordPress with Mingle. As we have a few members we wanted to search our database to pull out their first_name, last_name, location and their reason for joining (custom field generated in mingle).

    Actually knowing how to grab this information, export it as an excel csv or better still, be able to run a query to generate pretty data within wordpress as a plugin is driving me mad.

    How do you access your user data?

    Thanks

  2. petimi
    Member
    Posted 12 months ago #

    Hi,
    I would be interested to find out about this too.

    How do you extract user meta information?

    Is there a way to export name, email etc, the core wp user data and more importantly the custom fields and user photos?

    I am aware that there is no option for this through the backend but if someone point out which talbe/records you need to export from the mysql database it'd be great help.

    thanks.

  3. GRAQ
    Member
    Posted 11 months ago #

    http://codex.wordpress.org/Database_Description

    The users and user_meta tables contain core user data. It is most likely where themes and plugins store them too, but that's down to the author.

Topic Closed

This topic has been closed to new replies.

About this Topic