Obtaining random items of database

@dzuritaa

Noticias::where('url_foto', '!=',  ' ')
->where('id_tipos_noticias', 1)
->orderByRaw("RAND()")
->take(8)
->get()

There is also the random method on Collection but I think less performant.

"order by rand()" is bad, i recommend generating a random number that exist in your database and select where the id equals to that random number. Use the lists method on eloquent to get all the IDs available on your table.

@RachidLaasri what do you find bad with order by rand() ?

@bestmomo http://stackoverflow.com/a/16777862/4415507

@RachidLaasri http://stackoverflow.com/questions/4710048/good-idea-bad-idea-using-mysql-rand-outside-of-a-small-set-of-subquery-result

That says a subquery which is fine and you can read that on the URL i posted too, but does the author of this thread have a subquery?

I'll do some test to see what does.

привіт! код потрібно вдосконалити але можливо комусь підійде $count = self::count(); $randArr = []; $c=count($randArr);

    for($i=0;$i<5;++$i){
        $random_int = rand(1, $count);
        $arr = self::find($random_int);
        $key = in_array($arr, $randArr);

        if(!$key){
            array_push($randArr, $arr);
        }
    };
    
    return $randArr;