I’m trying to figure out how to create a complete list of all users, ordered by last name. Since I have around 800 users in the DB, I’m looking for a way to JOIN the wp_users and wp_usermeta tables and hopefully, but I’m not sure how to work this with the meta key/value structure.
Does anyone know how I could JOIN the two in a way that I can either sort the users in the SQL or in PHP withouth having to do an extra query for each user seperately?
Thanks in advance!
- The topic ‘Sorting authors by last name’ is closed to new replies.