List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 8 2003 9:46pm
Subject:RE: Random Selects
View as plain text  
At 15:32 -0600 3/8/03, Darren Young wrote:
>3.23.54 on Linux.
>
>And it worked. Thx. Seems to be "not so random", but then with more
>records to sample from the "randomness" would increase. True?

Probably.  However, if you check the change notes in the manual for
3.23.56, you'll see that RAND() initialization was modified to be
more random for new connections.

>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Saturday, March 08, 2003 2:33 PM
>To: Darren Young; mysql@stripped
>Subject: Re: Random Selects
>
>
>At 12:33 -0600 3/8/03, Darren Young wrote:
>>I have a table called testimonials:
>>
>>+----------+-------------+------+-----+---------+----------------+
>>| Field    | Type        | Null | Key | Default | Extra          |
>>+----------+-------------+------+-----+---------+----------------+
>>| id       | tinyint(3)  |      | PRI | NULL    | auto_increment |
>>| can_use  | tinyint(1)  |      |     | 0       |                |
>>| name     | varchar(64) |      |     | 0       |                |
>>| location | varchar(64) |      |     | 0       |                |
>>| quote    | text        |      |     |         |                |
>>+----------+-------------+------+-----+---------+----------------+
>>
>>That contains 20 or so "customer testimonial" comments. I want to
>>randomly display 3-4 of them every time a page loads (using PHP). Is
>>there some type of random selction available within MySQL, as in:
>>
>>     SELECT RANDOM(id),name,location,quote FROM testimonials WHERE
>>can_use=1 LIMIT 3;
>>
>>Or something to that effect or am I better served finding some way in
>>PHP to do this?
>
>
>.... ORDER BY RAND() LIMIT 3
>
>ought to do it, unless your version of MySQL is older than 3.23.2.
>
>>
>  >Thanks.

Thread
Random SelectsDarren Young8 Mar
  • Re: Random SelectsPaul DuBois8 Mar
    • RE: Random SelectsDarren Young8 Mar
      • RE: Random SelectsPaul DuBois8 Mar