WordPress.org

Support

Support » How-To and Troubleshooting » Search wp_usermeta table

Search wp_usermeta table

  • Hello,

    I am trying to create a search-able directory that displays all users of my blog but also can be searched by first name and last name in the wp_usermeta table. I can get it to search by one or the other but not by both. Anyone able to achieve this?

    SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key = 'first_name' AND meta_value LIKE 'A%' ORDER BY user_id

    If I am not clear please let me know.

    Thanks

  • The topic ‘Search wp_usermeta table’ is closed to new replies.