FQL SELECT查询，IN，NOT关键字 [英] FQL SELECT query with IN ,NOT Keyword

问题描述

我正在尝试找回所有希望很少有人见的朋友.

I'm trying to retrieve all my friends expect few people.

我这样形成查询

    SELECT uid,name FROM user WHERE uid NOT IN ($x)

检索每个期望有$ x的人.

Retrieve every one expect those people who are in $x.

This is giving me an fatal error Uncaught Exception: 601: Parser error: unexpected 'NOT

提前谢谢！

推荐答案

您可以使用WHERE NOT (columnName IN (things 'not in')

像这个例子:

SELECT post_id, message
 FROM stream 
 WHERE source_id IN ( SELECT page_id 
                        FROM page 
                       WHERE name='coca-cola'
                    ) 
   AND NOT (message IN ( 'probando cocacola'
                       , 'Stijn '
                       , 'Ha ha ha me crezy hu'
                       , ''
                       )
           )
LIMIT 50

这篇关于FQL SELECT查询，IN，NOT关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！