Help with displaying random records
View Single Post
11-25-2012, 11:50 AM
Join Date: Dec 2005
Thanked 76 Times in 76 Posts
select * from temp_table t left join temp_table t1 on t.f<> t1.f ORDER BY RAND() limit 5
As you said, you don't care if same record appears more than once.
Found a flower or bug and don't know what it is ?
if you don't spot search button at once, there is search form:
agrozoo.net galery search
View Public Profile
Visit BubikolRamios's homepage!
Find More Posts by BubikolRamios