SQL Codes

UPDATE wp_usermeta, wp_usermeta3 SET wp_usermeta.meta_value = ‘Exhibiting’ WHERE wp_usermeta.user_id = wp_usermeta3.user_id AND wp_usermeta.meta_key = ‘role’

INSERT INTO wp_usermeta3 (user_id,meta_key,meta_value) SELECT user_id,meta_key,meta_value FROM wp_usermeta WHERE meta_value = ‘Exhibiting’ and meta_key = ‘mem_cat’

SELECT w.user_id, w.meta_value, a.meta_value FROM wp_usermeta w INNER JOIN wp_usermeta a ON w.user_id = a.user_id WHERE (w.meta_value = ‘member’ AND w.meta_key = ‘role’) AND (a.meta_key = ‘last_name’ or a.meta_key = ‘first_name’)