id f_to f_from status
1 mike jener 0
2 mike jay 1
3 patric mike 1
4 mike lucy 1
status = 1 为正常好友关系,mike 就有三个好友,要怎么取出这三个好友的名字?
1 mike jener 0
2 mike jay 1
3 patric mike 1
4 mike lucy 1
status = 1 为正常好友关系,mike 就有三个好友,要怎么取出这三个好友的名字?
union
Select f_from from table1 where f_to='mike' and status=1