Freebase; select a random record?
Posted
by user168083
on Stack Overflow
See other posts from Stack Overflow
or by user168083
Published on 2010-04-21T04:19:12Z
Indexed on
2010/04/21
4:23 UTC
Read the original article
Hit count: 272
1) Is there any way to select a random record from Freebase? If I do a limit of 1, it consistently returns the same record. I could grab the larger data set and select a random rec from that but that seems like overkill. Analogous to MySQL's :
select * from profiles order by rand() limit 1;
2) Is there any way to tell Freebase not to select certain items in a set?
Analogous to MySQL's :
select * from profiles where id NOT IN (SELECT profile_id from approved_profiles)
Thanks in advance
© Stack Overflow or respective owner
