WordPress Database Query

Question

I'm trying to run a SQL query from a WordPress database. Basically, I need to get the email address of all users from the wp_users table and then check to see if those users have a value that is not null in the row 'agent_name' in the wp_usermeta table. So something like this pseudo code SELECT user_email FROM 'wp_users' and SELECT agent_name FROM 'wp_usermeta'. The goal is to have the query printed out in a csv (that part I can figure out). You can see an example of the kind of output I'm looking for in this screenshot:

enter image description here

I hope that makes sense.

Cyclonecode · Accepted Answer · 2015-07-09 14:31:43Z

1

You should use an INNER JOIN to achive this:

SELECT u.user_email, m.meta_value FROM wp_users u 
INNER JOIN wp_usermeta m ON m.user_id = u.ID && 
           m.meta_key = 'agent_name' && 
           m.meta_value IS NOT NULL

edited Jul 9, 2015 at 14:31

answered Jul 9, 2015 at 14:19

Cyclonecode

30.4k11 gold badges77 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Christian Over a year ago

Hmm, I just tried it and I'm getting no results with an error Uknown column 'm.agent_name' in 'field list'

Cyclonecode Over a year ago

@Christian - Oooops, It should be m.meta_value in the field list, updated my answer.

Collectives™ on Stack Overflow

WordPress Database Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related