FQL NOT IN等效的运算符，如<> ，除了，！= [英] FQL NOT IN Equivalent operator like <> , EXCEPT, !=

问题描述

我正在尝试开发以下代码:

I'm trying to develop this code:

$users = $facebook->api(array(
  'method' => 'fql.query',
  'query' =>    "SELECT uid, last_name, pic_big"
             + " FROM user WHERE uid IN ("
             + "     SELECT uid" 
             + "     FROM page_fan"
             + "     WHERE page_id='411133928921438'" 
             + "         AND uid IN ("
             + "             SELECT uid2 FROM friend WHERE uid1 = me()"
             + "         )"
             + ")"
));

这个想法是我不想使用运算符IN而不是NOT IN，但是FQL不支持像NOT IN这样的运算符，除了...我该如何用FQL做到这一点?...

The idea is that i don't want to use the operator IN but NOT IN, but FQL doesn't support operators like NOT IN, EXCEPT... How can i do it with FQL?...

推荐答案

FQL中没有 NOT IN 运算符.您可以使用 IN 进行简单选择，然后使用PHP进行否定.这有点开销，但据我所知，这是唯一的方法.

There is no NOT IN operator in FQL. You could do a simple select using IN and use PHP for negation. It's a little overhead, but as far as I know it's the only way.

我发现了一条相关的帖子:链接此处.

I found a related post: link here.

这篇关于FQL NOT IN等效的运算符，如<> ，除了，！=的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！