Facebook FQL LIKE operator
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/
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