Facebook Queries

Query for the facebook api to get posts related to a subject, this will get all posts that have the word “read” in it.

SELECT post_id,actor_id, target_id,message FROM stream WHERE filter_key = ‘others’

AND strpos(message, ‘read’) >= 0

Debug on facebook

 

Leave a comment