SELECT meta_value FROM tablename WHERE meta_key = first_name
SHould do the trick!
What we are doing is selecting the value in the meta-value column if the meta_key column says ‘first_name’
You can do the same for all fields
SELECT meta_value FROM tablename WHERE meta_key = admin_color
Would return ‘fresh’ from your screen-shot.
2
solved Weird accessing SQL data [closed]