SQL Help - Searching from multiple usergroups

[Nullifi3d]

[sql]$db->query_first("SELECT homepage AS url FROM user WHERE usergroupid = 5 || 6 || 7 || 9 ||12 AND homepage != '' AND lastpost > UNIX_TIMESTAMP(NOW())-86400 ORDER BY RAND() LIMIT 1");[/sql]
The query above works only with 2 numbers in the usergroupid field (one OR). Once I move it up to 3 it fails to work correctly. How do I fix?

[Spam.Diz]

Why is the limit 1 there? I thought that meant after getting one found stop. Remove the limit 1 and see what happens.

[Nullifi3d]

The LIMIT 1 needs to be there. I only need one random homepage, but it selected (randomly) from several different usergroups.

[calorie]

[sql]
$db->query_first("SELECT homepage AS url FROM user WHERE usergroupid IN (5,6,7,9,12) AND homepage != '' AND lastpost > UNIX_TIMESTAMP(NOW())-86400 LIMIT 1");
[/sql]

[Nullifi3d]

Thanks a bunch.