Need help building mysql query in phpmyadmin

[ben bibik]

I need to view some information from a wordpress table but it is way over my head because it is contained in a meta_value

In a wp_usermeta table there are several keys,
umeta_id
user_id
meta_key
meta_value

meta_key has a mgm_member_options value and I need to query all the data stored in meta_value for mgm_member_options.

Any idea how I can build a query in phpmyadmin to view all this data in a table row structure?

Here is the screenshot of what I'm talking about:


Thanks
Ben



Edited 3 time(s). Last edit at 08/29/2012 09:42PM by ben bibik.