开发者

fql - fbconnect getting first post ever

开发者 https://www.devze.com 2023-01-05 16:25 出处:网络
I want to get the first stream record ever. I tried: SELECT post_id,created_time FROM stream WHERE source_id = 610611346 ORDER BY created_time ASC LIMIT 1

I want to get the first stream record ever. I tried:

SELECT post_id,created_time FROM stream WHERE source_id = 610611346 ORDER BY created_time ASC LIMIT 1

But it gives me the LATEST instead of the FIRST post :(. I increased the limit to 5 just to have a look at what it was bringing back and it is simply the last 5 posts in ascending order. I guess I'm confusing LIMIT with like a开发者_JS百科n index. How can this be done?

Mike


What happens if you:

SELECT post_id,created_time FROM stream WHERE source_id = 610611346 ORDER BY created_time DESC LIMIT 1
0

精彩评论

暂无评论...
验证码 换一张
取 消