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

Question

我尝试在一个 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

Answer 1

使用 AND 就足够了：

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

Answer 2

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

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