Laravel - Eloquent or Fluent random row

Question

How can I select a random row using Eloquent or Fluent in Laravel framework   I know that by using SQL  you can do order by RAND    However  I would like to get the random row without doing a count on the number of records prior to the initial query   Any ideas

User · Answer

In Laravel 4 and 5 the order by is replaced by orderBy  So  it should be   User  orderBy DB  raw  RAND     - gt get

User · Answer

You can easily Use this command      Question   name of Model    take 10 rows from DB In shuffle records      questions   Question  orderByRaw  RAND    - gt take 10 - gt get

User · Answer

tl dr  It s nowadays implemented into Laravel  see  edit 3  below     Sadly  as of today there are some caveats with the - gt orderBy DB  raw  RAND      proposed solution    It isn t DB-agnostic  e g  SQLite and PostgreSQL use RANDOM   Even worse  this solution isn t applicable anymore since this change    direction   strtolower  direction      asc     asc     desc      edit  Now you can use the orderByRaw   method  - gt orderByRaw  RAND      However this is still not DB-agnostic   FWIW  CodeIgniter implements a special RANDOM sorting direction  which is replaced with the correct grammar when building query  Also it seems to be fairly easy to implement  Looks like we have a candidate for improving Laravel     update  here is the issue about this on GitHub  and my pending pull request    edit 2  Let s cut the chase  Since Laravel 5 1 18 you can add macros to the query builder   use Illuminate Database Query Builder   Builder  macro  orderByRandom   function            randomFunctions              mysql     gt   RAND              pgsql     gt   RANDOM              sqlite    gt   RANDOM              sqlsrv    gt   NEWID                  driver    this- gt getConnection  - gt getDriverName         return  this- gt orderByRaw  randomFunctions  driver          Usage   User  where  active   1 - gt orderByRandom  - gt limit 10 - gt get     DB  table  users  - gt where  active   1 - gt orderByRandom  - gt limit 10 - gt get       edit 3  Finally  Since Laravel 5 2 33  changelog  PR  13642  you can use the native method inRandomOrder     User  where  active   1 - gt inRandomOrder  - gt limit 10 - gt get     DB  table  users  - gt where  active   1 - gt inRandomOrder  - gt limit 10 - gt get

User · Answer

This works just fine    model Model  all  - gt random 1 - gt first      you can also change argument in random function to get more than one record   Note  not recommended if you have huge data as this will fetch all rows first and then returns random value

User · Answer

In Laravel 7 x and above  you can just do   data   Images  all  - gt random 4

User · Answer

Laravel has a built-in method to shuffle the order of the results   Here is a quote from the documentation   shuffle     The shuffle method randomly shuffles the items in the collection    collection   collect  1  2  3  4  5      shuffled    collection- gt shuffle      shuffled- gt all         3  2  5  1  4  -  generated randomly    You can see the documentation here

User · Answer

I prefer to specify first or fail    collection   YourModelName  inRandomOrder     - gt firstOrFail

User · Answer

There is also whereRaw  RAND     which does the same  you can then chain - gt get   or - gt first   or even go crazy and add - gt paginate int

User · Answer

You can also use order by method with fluent and eloquent like as   Posts  where status 1 - gt order by DB  raw     DB  raw  RAND          This is a little bit weird usage  but works   Edit  As  Alex said  this usage is cleaner and also works   Posts  where status 1 - gt order by DB  raw  RAND

User · Answer

You can use   ModelName  inRandomOrder  - gt first

User · Answer

Use Laravel function    ModelName  inRandomOrder  - gt first

User · Answer

Laravel  gt   5 2  User  inRandomOrder  - gt get     or to get the specific number of records    5 indicates the number of records User  inRandomOrder  - gt limit 5 - gt get       get one random record User  inRandomOrder  - gt first     or using the random method for collections  User  all  - gt random    User  all  - gt random 10      The amount of items you wish to receive  Laravel 4 2 7 - 5 1  User  orderByRaw  quot RAND   quot  - gt get     Laravel 4 0 - 4 2 6  User  orderBy DB  raw  RAND     - gt get     Laravel 3  User  order by DB  raw  RAND     - gt get     Check this article on MySQL random rows  Laravel 5 2 supports this  for older version  there is no better solution then using RAW Queries  edit 1  As mentioned by Double Gras  orderBy   doesn t allow anything else then ASC or DESC since this change  I updated my answer accordingly  edit 2  Laravel 5 2 finally implements a wrapper function for this  It s called inRandomOrder

User · Answer

For Laravel 5 2     use the Eloquent method        inRandomOrder     The inRandomOrder method may be used to sort the query results randomly  For example  you may use this method to fetch a random user    randomUser   DB  table  users               - gt inRandomOrder               - gt first      from docs  https   laravel com docs 5 2 queries ordering-grouping-limit-and-offset

User · Answer

At your model add this   public function scopeRandomize  query   limit   3   exclude              query    query- gt whereRaw  RAND   lt  SELECT     COUNT     10  FROM  products       limit  - gt orderByRaw  RAND    - gt limit  limit       if   empty  exclude              query    query- gt whereNotIn  id    exclude             return  query      then at route controller   data   YourModel  randomize 8 - gt get

User · Answer

I have table with thousands of records  so I need something fast  This is my code for pseudo random row      count all rows with flag active   1  count   MyModel  where  active         1  - gt count         get random id  random id   rand 1   count - 1         get first record after random id  data   MyModel  where  active         1  - gt where  id     gt     random id - gt take 1 - gt first

[php] Laravel - Eloquent or Fluent random row

Examples related to php

Examples related to laravel

Examples related to random

Examples related to eloquent

Examples related to fluent