Facebook FQL LIKE 运算符
是否可以在 Facebook 的查询语言中使用熟悉的 SQL LIKE 运算符？
我尝试在 FQL 测试控制台中运行查询，但它不起作用。我想知道我是否遗漏了某些东西或者根本不可能？
SELECT link_id from link WHERE url LIKE '%FRLJTjNC8So%' AND owner = '421235'
去这里测试一下： http://developers.facebook.com/docs/reference/rest/fql .query/
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/
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SELECT link_id from link WHERE strpos(url,'FRLJTjNC8So') >=0 ANDowner = '421235'FQL 中没有 SQL
LIKE。我的解决方案使用 FQLSTRPOS代替。这有效是因为它在
URL字段中搜索子字符串FRLJTjNC8So。以下线程很有帮助
facebook fql 是否包含 sql like 运算符？
SELECT link_id from link WHERE strpos(url,'FRLJTjNC8So') >=0 AND owner = '421235'There is no SQL
LIKEin FQL. My solution uses FQLSTRPOSinstead. This works because itsearches for the substring
FRLJTjNC8Sowithin theURLfield.The following thread was helpful
Does facebook fql contain the sql like operator?