While fetching: https://api.facebook.com/method/fql.query?query=Select+page_id,page_url,name,pic,website,type,location,fan_count,phone+from+page+where+name%20%20=%22SPA%22 i am getting all exact match results with "SPA" But how to get other which will match "sp" as well. Like when we use like operator in fql i am getting problem. Please suggest me with solution
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
here you go:
WHERE strpos(lower(name), 'sp') >= 0
回答2:
Hence there is no LIKE operator in FQL, you will have to use other alternative. I hope this link will suggest you some way:
Does facebook fql contain the sql like operator?