是否允许在FQL中使用两个WHERE子句

Is it allowed to use two WHERE clauses in FQL?

本文关键字：两个子句 WHERE FQL 是否 | 更新日期: 2023-09-27

我正试图在一个fql查询中使用两个WHERE子句

SELECT uid, pic, pic_square, name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) AND WHERE strstr('ab',name)

Parser error: unexpected 'WHERE' at position

SELECT .... 
FROM ..... 
WHERE ((Condition A) AND (Condition B))

右括号错误，或者您错过了一个完整的（第二个）子select子句。

SELECT uid, pic, pic_square, name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()    ====>>) AND ====>>WHERE strstr('ab',name)