Facebook FQL LIKE operator

sql facebook facebook-fql
Alan David Garcia picture Alan David Garcia · Feb 14, 2011 · Viewed 13.9k times · Source

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/

Answer

Alan David Garcia picture Alan David Garcia · Feb 14, 2011

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?

Related questions

Facebook database design?

I have always wondered how Facebook designed the friend <-> user relation. I figure the user table is something like this: user_email PK user_id PK password I figure the table with user's data (sex, age etc …

Read More
Storing Friends in Database for Social Network

For storing friends relationships in social networks, is it better to have another table with columns relationship_id, user1_id, user2_id, time_created, pending or should the confirmed friend's user_id be seralized/imploded into a single long string …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More