advanced code snippet search

We Recommend

Wicked Cool PHP: Real-World Scripts That Solve Difficult Problems Wicked Cool PHP: Real-World Scripts That Solve Difficult Problems
Wicked Cool PHP contains a wide variety of scripts to process credit cards, check the validity of email addresses, template HTML, and serve dynamic images and text.

Posted By

Tamedo on 06/04/08


Tagged


Versions (?)


Speed up RAND() on large data sets

Published in: PHP 

Plain TextExpand 
  1. $query2  = "SELECT * FROM table T JOIN (SELECT MAX(id) AS id FROM table) AS x ON T.id >= FLOOR(x.id*RAND()) LIMIT 10;";

Report this snippet 

You need to login to post a comment.