duanfu1873 2012-01-11 06:29
浏览 30
已采纳

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

I am trying to use two WHERE clauses in one fql query

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

but getting error

Parser error: unexpected 'WHERE' at position
  • 写回答

2条回答 默认 最新

  • douxiezha9319 2012-01-11 06:33
    关注

    Its enough to use AND like:

    SELECT .... 
    FROM ..... 
    WHERE ((Condition A) AND (Condition B))
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效