Search for people by name in FQL?

Later edit Ok, sorry for the mistake regarding strpos, I didn't remeber it existence last time I checked the fql docs. The thing about it is that it can be used just in certain cases. You need to have a primar indexable column in your where clause and a second condition with strpos (at least this is how I succeded using it).

For example: SELECT actor_id, message FROM stream WHERE source_id = me() AND strpos(message, 'stuff') > 0 limit 50 I hope this clarifies a little bit the confusion with this function First of all strpos(name, 'Alfredo Artiles') is a way of doing it in a programming language like php, in fql (sql) there is no such thing The documentation for the user table can be found here As you can see, the indexable columns are uid name and username So a valid query would be something like this: SELECT uid, username, name, pic_square FROM user WHERE name = 'Alfredo Artiles Good Luck!

Later edit Ok, sorry for the mistake regarding strpos, I didn't remeber it existence last time I checked the fql docs. The thing about it is that it can be used just in certain cases. You need to have a primar indexable column in your where clause and a second condition with strpos (at least this is how I succeded using it).

For example: SELECT actor_id, message FROM stream WHERE source_id = me() AND strpos(message, 'stuff') > 0 limit 50 I hope this clarifies a little bit the confusion with this function. First of all strpos(name, 'Alfredo Artiles') is a way of doing it in a programming language like php, in fql (sql) there is no such thing. The documentation for the user table can be found here.As you can see, the indexable columns are uid, name and username.

So a valid query would be something like this: SELECT uid, username, name, pic_square FROM user WHERE name = 'Alfredo Artiles' Good Luck!

FQL has now(), strlen(), substr() and strpos() check it here developers.facebook. Com/docs/reference/fql – aartiles Dec 7 '10 at 21:34 Your query returns only exact matchs – aartiles Dec 7 '10 at 21:36 sorry for the mistake with strpos, please recheck my answer to see what I edited – misterjinx Dec 8 '10 at 7:32 What you says seems to make sense but doesn't help me. Is there any way to make a fulltext search using FQL?

– aartiles Dec 8 '10 at 19:44 fulltext search? Like mysql fulltext? No, it is not possible.

– misterjinx Dec 8 '10 at 20:12.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.