{"id":553,"date":"2023-06-30T18:03:48","date_gmt":"2023-06-30T18:03:48","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=553"},"modified":"2023-06-30T18:03:50","modified_gmt":"2023-06-30T18:03:50","slug":"example-how-to-get-random-records-from-database-in-laravel","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/","title":{"rendered":"Example: How to Get Random Records from Database in Laravel"},"content":{"rendered":"\n<p>Let&#8217;s look at a lesson on getting records in random order in Laravel right away. You&#8217;ll find a straightforward example of how to acquire a random record from a model in this post. Laravel may be shown obtaining random data from a database. We will assist you by providing a sample of how to retrieve a random record from a database using Laravel.<\/p>\n\n\n\n<p>This example works with versions of Laravel 6, Laravel 7, Laravel 8, Laravel 9, and Laravel 10.<\/p>\n\n\n\n<p>I&#8217;ll show you two straightforward methods in this post for ordering random records from a database in Laravel. To obtain random records, we will utilise the MySQL functions inRandomOrder() and RAND().<\/p>\n\n\n\n<p>So, let&#8217;s go over both examples in detail.<\/p>\n\n\n\n<p><strong>Controller Code:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n    \nnamespace App\\Http\\Controllers;\n    \nuse Illuminate\\Http\\Request;\nuse App\\Models\\User;\n    \nclass UserController extends Controller\n{\n    \/**\n     * Write code on Method\n     *\n     * @return response()\n     *\/\n    public function index()\n    {\n        $users = User::select(\"*\")\n                        -&gt;inRandomOrder()\n                        -&gt;get();\n    \n        dd($users-&gt;toArray());\n    }\n}<\/code><\/pre>\n\n\n\n<p><strong>Controller Code:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n    \nnamespace App\\Http\\Controllers;\n    \nuse Illuminate\\Http\\Request;\nuse App\\Models\\User;\nuse DB;\n    \nclass UserController extends Controller\n{\n    \/**\n     * Write code on Method\n     *\n     * @return response()\n     *\/\n    public function index()\n    {\n        $users = User::select(\"*\")\n                        -&gt;orderBy(DB::raw('RAND()'))\n                        -&gt;get();\n    \n        dd($users-&gt;toArray());\n    }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Let&#8217;s look at a lesson on getting records in random order in Laravel right away. You&#8217;ll find a straightforward example of how to acquire a random record&#8230; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[100],"class_list":["post-553","post","type-post","status-publish","format-standard","hentry","category-laravel","tag-how-to-get-random-records-from-database-in-laravel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Example: How to Get Random Records from Database in Laravel - DevOps Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Example: How to Get Random Records from Database in Laravel - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"Let&#8217;s look at a lesson on getting records in random order in Laravel right away. You&#8217;ll find a straightforward example of how to acquire a random record...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-30T18:03:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-30T18:03:50+00:00\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"Example: How to Get Random Records from Database in Laravel\",\"datePublished\":\"2023-06-30T18:03:48+00:00\",\"dateModified\":\"2023-06-30T18:03:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/\"},\"wordCount\":132,\"commentCount\":2,\"keywords\":[\"How to Get Random Records from Database in Laravel\"],\"articleSection\":[\"Laravel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/\",\"name\":\"Example: How to Get Random Records from Database in Laravel - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"datePublished\":\"2023-06-30T18:03:48+00:00\",\"dateModified\":\"2023-06-30T18:03:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/example-how-to-get-random-records-from-database-in-laravel\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Example: How to Get Random Records from Database in Laravel - DevOps Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/","og_locale":"en_US","og_type":"article","og_title":"Example: How to Get Random Records from Database in Laravel - DevOps Consulting","og_description":"Let&#8217;s look at a lesson on getting records in random order in Laravel right away. You&#8217;ll find a straightforward example of how to acquire a random record...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/","og_site_name":"DevOps Consulting","article_published_time":"2023-06-30T18:03:48+00:00","article_modified_time":"2023-06-30T18:03:50+00:00","author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"Example: How to Get Random Records from Database in Laravel","datePublished":"2023-06-30T18:03:48+00:00","dateModified":"2023-06-30T18:03:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/"},"wordCount":132,"commentCount":2,"keywords":["How to Get Random Records from Database in Laravel"],"articleSection":["Laravel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/","url":"https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/","name":"Example: How to Get Random Records from Database in Laravel - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"datePublished":"2023-06-30T18:03:48+00:00","dateModified":"2023-06-30T18:03:50+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/example-how-to-get-random-records-from-database-in-laravel\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=553"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/553\/revisions"}],"predecessor-version":[{"id":555,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/553\/revisions\/555"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}