Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Facebook FQL LIKE operator [duplicate]

Possible Duplicates:
Does facebook fql contain the sql like operator?
FaceBook query using FQL

Is it possible to use the familiar SQL LIKE operator within Facebook's query language?

I have tried running the query in the FQL test console, but it doesn't work. I'm wondering if I'm missing something or if it is simply not possible?

SELECT link_id from link WHERE url LIKE '%FRLJTjNC8So%' AND owner = '421235'

Go here to test: http://developers.facebook.com/docs/reference/rest/fql.query/

like image 805
Alan David Garcia Avatar asked Feb 14 '11 20:02

Alan David Garcia


1 Answers

SELECT link_id from link WHERE strpos(url,'FRLJTjNC8So') >=0 AND owner = '421235'

There is no SQL LIKE in FQL. My solution uses FQL STRPOS instead. This works because it searches for the substring FRLJTjNC8So within the URL field.

The following thread was helpful

Does facebook fql contain the sql like operator?

like image 115
Alan David Garcia Avatar answered Nov 18 '22 12:11

Alan David Garcia