FQL: いろいろな条件式
FacebookのFQLで役に立つ条件式
*** 特定の文字列や値の一致***
select name from user where strpos(lower(name), 'imoto') >= 0 and uid in (select uid2 from friend where uid1 = me() )
appを利用しているuserのみを抽出
select name from user where is_app_user=1 and uid in (select uid2 from friend where uid1 = me() )
8月5日が誕生日の人
select uid , name , birthday from user where uid in (select uid2 from friend where uid1 = me() ) AND substr(birthday_date, 0, 5) = "08/05"
offset , order , limit の利用
select uid , name from user where uid in (select uid2 from friend where uid1 = me() ) order by uid desc limit 2 , 2
自分のwallで見える、友だちからの投稿に対して、いいね!を付けた日付順
SELECT created_time , post_id, actor_id, target_id, message FROM stream WHERE likes.user_likes=1 and source_id in (select uid2 from friend where uid1 = me() ) AND created_time >1341602545 order by created_time desc LIMIT 50
自分が過去に”いいね!”を押したFacebook page
SELECT name, description , website , fan_count FROM page WHERE page_id in ( SELECT id FROM object_url WHERE url in (select url from url_like where user_id=me() ))
Author And Source
この問題について(FQL: いろいろな条件式), 我々は、より多くの情報をここで見つけました https://qiita.com/Peko10/items/66aba4111f50a7bfe694著者帰属:元の著者の情報は、元のURLに含まれています。著作権は原作者に属する。
Content is automatically searched and collected through network algorithms . If there is a violation . Please contact us . We will adjust (correct author information ,or delete content ) as soon as possible .