开发者

FQL: how to use WHERE clause in array-type fields?

开发者 https://www.devze.com 2023-02-11 20:59 出处:网络
i want to select some feed from stream table. my problem is i just want results from specific \'text\' in action_links fields..

i want to select some feed from stream table. my problem is i just want results from specific 'text' in action_links fields..

action_links is field with array type.. i don开发者_如何学JAVA't know how to use WHERE clause in that field..

how to do that?

i am use this query but fail..

$q = 'SELECT permalink FROM stream';
$q.= " WHERE filter_key='cg' AND app_id = 'xxxxxxx'";
$q.= " AND action_links.text = 'zzzzzzz'";

EDIT: it imposible for now.. because Facebook not support that yet...


I don't think this is possible, since the operations you can use are:

Other functions that are available are now(), strlen(), substr() and strpos().

So basically most of them are for strings and not array.

One side note, action_links is an array and not object, so action_links.text is not correct anyway.

0

精彩评论

暂无评论...
验证码 换一张
取 消