使用FQL的随机朋友 [英] Random Friend using FQL

问题描述

我现在正在使用fql，它将所有朋友列表带入数组.然后，我对该数组进行排序以得到一个随机的朋友.

I am right now using fql which brings all the friend list in array. Then I sort that array to get a random friend.

但是似乎要花很长时间，因为我必须收集所有朋友才能得到一个随机的朋友.

But it seems to take long time since i have to collect all the friends to get single random friend.

我该如何在fql中获得随机的朋友?

How do i go this in fql to get random friend?

SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me())

推荐答案

SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me()) order by rand() limit 1

这篇关于使用FQL的随机朋友的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！