[Solved] Weird accessing SQL data [closed]


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]