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()
andstrpos()
.
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.
精彩评论