{"version":"1.0","provider_name":"Ver mi IP","provider_url":"https:\/\/vermiip.es\/blog","title":"Consulta SQL que muestre datos aleatorios (MySQL) - Ver mi IP","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"qb2ZILNEZq\"><a href=\"https:\/\/vermiip.es\/blog\/consulta-sql-que-muestre-datos-aleatorios-mysql\/\">Consulta SQL que muestre datos aleatorios (MySQL)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vermiip.es\/blog\/consulta-sql-que-muestre-datos-aleatorios-mysql\/embed\/#?secret=qb2ZILNEZq\" width=\"600\" height=\"338\" title=\"\u00abConsulta SQL que muestre datos aleatorios (MySQL)\u00bb \u2014 Ver mi IP\" data-secret=\"qb2ZILNEZq\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/vermiip.es\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Para sacar de una tabla los resultados ordenados de manera aleatoria se utiliza \u00abRAND()\u00bb. Pongamos el caso que de una tabla que tiene 550 registros queremos sacar 20 de manera aleatoria. La consulta quedar\u00eda as\u00ed: [SQL] SELECT * FROM nombre_tabla ORDER BY RAND() LIMIT 20; [\/SQL] Cada vez que realicemos la consulta sacaremos 20 registros [&hellip;]","thumbnail_url":"https:\/\/vermiip.es\/blog\/wp-content\/uploads\/2023\/10\/cropped-logo-vermiip-naranja.png","thumbnail_width":512,"thumbnail_height":512}