Facebook FQL LIKE operator

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/

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?


Need Your Help

Problem with regexp python and sqlite

python regex sqlite

I try to check a string with a pattern using a regex with python on a sqlite database.

How to Consume a Restful Service in .NET?

c# .net rest

What are my options to consume a RESTful service using the .Net framework? When is WCF(using the WebChannelFactory) more preferable to HttpClient?