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.