{"id":478,"date":"2009-12-27T12:41:16","date_gmt":"2009-12-27T12:41:16","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=478"},"modified":"2023-12-29T05:44:04","modified_gmt":"2023-12-29T12:44:04","slug":"mysql-select-random","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/","title":{"rendered":"MySQL Select Random Records"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn various techniques to <strong>select random records <\/strong>from a database table in MySQL.<\/p>\n\n\n\n<p>Sometimes, you have to select random records from a table, for example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select some random posts in a blog and display them in the sidebar.<\/li>\n\n\n\n<li>Select a random quote for displaying the &#8220;quote of the day&#8221; widget.<\/li>\n\n\n\n<li>Select random pictures in a gallery and use them as the featured pictures.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Selecting random records using ORDER BY RAND()<\/h2>\n\n\n\n<p>MySQL does not have any built-in statement to select random rows from a\u00a0 table. In order to accomplish this, you use the <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-math-functions\/mysql-rand\/\">RAND()<\/a><\/code> function.<\/p>\n\n\n\n<p>The following query selects a random row from a database table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * \n<span class=\"hljs-keyword\">FROM<\/span> table_name\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">RAND<\/span>()\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Let&#8217;s examine the query in more detail.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The function <code>RAND()<\/code> generates a random value for each row in the table.<\/li>\n\n\n\n<li>The <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-order-by\/\">ORDER BY<\/a><\/code>&nbsp;clause sorts all rows in the table by the random number generated by the <code>RAND()<\/code> function.<\/li>\n\n\n\n<li>The <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-limit\/\">LIMIT<\/a><\/code>clause picks the first row in the result set sorted randomly.<\/li>\n<\/ul>\n\n\n\n<p>If you want to select <code>N<\/code> random records from a database table, you need to change the <code>LIMIT<\/code> clause as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> table_name\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">RAND<\/span>()\n<span class=\"hljs-keyword\">LIMIT<\/span> N;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>See the following <code>customers<\/code> table from the <a href=\"https:\/\/www.mysqltutorial.org\/getting-started-with-mysql\/mysql-sample-database\/\">sample database<\/a>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg\" alt=\"\" class=\"wp-image-10765\"\/><\/figure>\n\n\n\n<p>The following example selects five random customers from the <code>customers<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n    customerNumber, \n    customerName\n<span class=\"hljs-keyword\">FROM<\/span>\n    customers\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">RAND<\/span>()\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">5<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><a class=\"sql\" href=\"https:\/\/www.mysqltutorial.org\/tryit\/query\/mysql-select-random\/#1\" target=\"_blank\" rel=\"noopener noreferrer\">Try It Out<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"273\" height=\"134\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2009\/12\/mysql-select-random-customers.jpg\" alt=\"mysql select random customers\" class=\"wp-image-3958\" title=\"mysql select random customers\"\/><\/figure>\n\n\n\n<p>Notice that you may get a different result set because it is random.<\/p>\n\n\n\n<p>This technique works very well with a small table. However, it will be slow for the big table because MySQL has to sort the entire table to select the random ones.<\/p>\n\n\n\n<p>The speed of the query also depends on the number of rows in the table. The more rows the table has, the more time it takes to generate the random number for each row.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Selecting random records using an INNER JOIN clause<\/h2>\n\n\n\n<p>This technique requires that the table has an <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-auto_increment\/\">auto-increment<\/a> <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-primary-key\/\">primary key<\/a> field and there is no gap in the <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-auto_increment\/\">sequence<\/a>.<\/p>\n\n\n\n<p>The following query generates a random number based on the <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-primary-key\/\">primary key<\/a> column:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n   <span class=\"hljs-keyword\">ROUND<\/span>(<span class=\"hljs-keyword\">RAND<\/span>() * ( <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">MAX<\/span>(<span class=\"hljs-keyword\">id<\/span>) <span class=\"hljs-keyword\">FROM<\/span>  table_name)) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">id<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>We can <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-inner-join\/\">join <\/a>the table with the result set returned by the above query as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> t.*\n<span class=\"hljs-keyword\">FROM<\/span> table_name <span class=\"hljs-keyword\">AS<\/span> t\n<span class=\"hljs-keyword\">INNER<\/span> <span class=\"hljs-keyword\">JOIN<\/span>\n    (<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">ROUND<\/span>(\n       <span class=\"hljs-keyword\">RAND<\/span>() * \n      (<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">MAX<\/span>(<span class=\"hljs-keyword\">id<\/span>) <span class=\"hljs-keyword\">FROM<\/span> table_NAME )) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">id<\/span>\n     ) <span class=\"hljs-keyword\">AS<\/span> x\n<span class=\"hljs-keyword\">WHERE<\/span>\n    t.id &gt;= x.id\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Using this technique, you must execute the query multiple times to get more than one random row because if you increase the limit, the query will only give you sequential rows that start from the randomly selected row.<\/p>\n\n\n\n<p>The following query returns a random customer from the <code>customers<\/code> table.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n    t.customerNumber, t.customerName\n<span class=\"hljs-keyword\">FROM<\/span>\n    customers <span class=\"hljs-keyword\">AS<\/span> t\n        <span class=\"hljs-keyword\">JOIN<\/span>\n    (<span class=\"hljs-keyword\">SELECT<\/span> \n        <span class=\"hljs-keyword\">ROUND<\/span>(<span class=\"hljs-keyword\">RAND<\/span>() * (<span class=\"hljs-keyword\">SELECT<\/span> \n                    <span class=\"hljs-keyword\">MAX<\/span>(customerNumber)\n                <span class=\"hljs-keyword\">FROM<\/span>\n                    customers)) <span class=\"hljs-keyword\">AS<\/span> customerNumber\n    ) <span class=\"hljs-keyword\">AS<\/span> x\n<span class=\"hljs-keyword\">WHERE<\/span>\n    t.customerNumber &gt;= x.customerNumber\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><a class=\"sql\" href=\"https:\/\/www.mysqltutorial.org\/tryit\/query\/mysql-select-random\/#2\" target=\"_blank\" rel=\"noopener noreferrer\">Try It Out<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"253\" height=\"47\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2009\/12\/mysql-select-random-customers-using-join1.jpg\" alt=\"mysql select random customers using join\" class=\"wp-image-3957\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Selecting random records using variables<\/h2>\n\n\n\n<p>In case the table has <code>id<\/code> column with the values that fall within a range <code>1..N<\/code> and there is no gap in the range, you can use the following technique:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, select random numbers in the range 1..N.<\/li>\n\n\n\n<li>Second, pick the records based on the random numbers.<\/li>\n<\/ul>\n\n\n\n<p>The following statement helps you accomplish this:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n    table. *\n<span class=\"hljs-keyword\">FROM<\/span>\n    (<span class=\"hljs-keyword\">SELECT<\/span> \n        <span class=\"hljs-keyword\">ROUND<\/span>(<span class=\"hljs-keyword\">RAND<\/span>() * (<span class=\"hljs-keyword\">SELECT<\/span> \n                    <span class=\"hljs-keyword\">MAX<\/span>(<span class=\"hljs-keyword\">id<\/span>)\n                <span class=\"hljs-keyword\">FROM<\/span>\n                    <span class=\"hljs-keyword\">table<\/span>)) random_num,\n            @<span class=\"hljs-keyword\">num<\/span>:=@<span class=\"hljs-keyword\">num<\/span> + <span class=\"hljs-number\">1<\/span>\n    <span class=\"hljs-keyword\">FROM<\/span>\n        (<span class=\"hljs-keyword\">SELECT<\/span> @<span class=\"hljs-keyword\">num<\/span>:=<span class=\"hljs-number\">0<\/span>) <span class=\"hljs-keyword\">AS<\/span> a, <span class=\"hljs-keyword\">table<\/span>\n    <span class=\"hljs-keyword\">LIMIT<\/span> N) <span class=\"hljs-keyword\">AS<\/span> b,\n    <span class=\"hljs-keyword\">table<\/span> <span class=\"hljs-keyword\">AS<\/span> t\n<span class=\"hljs-keyword\">WHERE<\/span>\n    b.random_num = t.id;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Note that the user-defined variables are connection-specific. This means that this technique cannot be used with the connection pooling. In addition, the primary key must be integer type and its values must be in the sequence without gaps.<\/p>\n\n\n\n<p>In this tutorial, we have shown you several techniques to select random records from a table.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"478\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/\"\n\t\t\t\tdata-post-title=\"MySQL Select Random Records\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"478\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/\"\n\t\t\t\tdata-post-title=\"MySQL Select Random Records\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Shows you various techniques to select random records from a database table.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":174,"menu_order":96,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-478","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL Select Random Records<\/title>\n<meta name=\"description\" content=\"This tutorial introduces you to some techniques to select random records from a database table in MySQL.\" \/>\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.mysqltutorial.org\/mysql-basics\/mysql-select-random\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Select Random Records\" \/>\n<meta property=\"og:description\" content=\"This tutorial introduces you to some techniques to select random records from a database table in MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-29T12:44:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/\",\"name\":\"MySQL Select Random Records\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/customers.svg\",\"datePublished\":\"2009-12-27T12:41:16+00:00\",\"dateModified\":\"2023-12-29T12:44:04+00:00\",\"description\":\"This tutorial introduces you to some techniques to select random records from a database table in MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/customers.svg\",\"contentUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/customers.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-select-random\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Basics\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL Select Random Records\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Select Random Records","description":"This tutorial introduces you to some techniques to select random records from a database table in MySQL.","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.mysqltutorial.org\/mysql-basics\/mysql-select-random\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Select Random Records","og_description":"This tutorial introduces you to some techniques to select random records from a database table in MySQL.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-12-29T12:44:04+00:00","og_image":[{"url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/","url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/","name":"MySQL Select Random Records","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/#primaryimage"},"image":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg","datePublished":"2009-12-27T12:41:16+00:00","dateModified":"2023-12-29T12:44:04+00:00","description":"This tutorial introduces you to some techniques to select random records from a database table in MySQL.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/#primaryimage","url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg","contentUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/customers.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-random\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Basics","item":"https:\/\/www.mysqltutorial.org\/mysql-basics\/"},{"@type":"ListItem","position":3,"name":"MySQL Select Random Records"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=478"}],"version-history":[{"count":1,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/478\/revisions"}],"predecessor-version":[{"id":11944,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/478\/revisions\/11944"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/174"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}