MySQL Query Output -

i'm new mysql , have run problem when trying run query.

ultimately trying run query display in table.

my query is:

    select           users.user_email n_user_user_email,         t1.meta_value n_user_first_name,          t2.meta_value n_user_last_name,          t3.meta_value n_user_profile_picture,          t4.meta_value n_user_position,          t5.meta_value n_user_hours,          t6.meta_value n_user_status,          t7.meta_value n_user_type  users left join usermeta t1 on t1.user_id = users.id  left join usermeta t2 on t1.user_id = t2.user_id  left join usermeta t3 on t2.user_id = t3.user_id   left join usermeta t4 on t3.user_id = t4.user_id  left join usermeta t5 on t4.user_id = t5.user_id  left join usermeta t6 on t5.user_id = t6.user_id  left join usermeta t7 on t6.user_id = t7.user_id     t1.meta_key = 'first_name'  , t2.meta_key = 'last_name'  , t3.meta_key = 'profile_picture'  , t4.meta_key = 'position' , t5.meta_key = 'hours'  , t6.meta_key = 'status' , t7.meta_key = 'type' 

my problem output. example position field outputting a:5:{i:0;s:14:"manager";i:1;s:10:"supervisor";

i want display 'manager' , supervisor etc.

how can achieve this? please bear in mind new , learning go along.

any or advice appreciated

mysql

share|improve question

asked jul 7 '15 @ 20:07 trinciar 1