From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 17, 2008 5:32 PM
To: mysql@lists.mysql.com
Subject: improving random record selection
I posted this a month or so ago, and was helped a little, but I am now
back.
Currently I use select x, y, z from images where (condition) order
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 17, 2008 6:47 PM
To: Scott Haneda
Cc: mysql@lists.mysql.com
Subject: Re: improving random record selection
On Sat, May 17, 2008 at 2:32 PM, Scott Haneda [EMAIL PROTECTED]
wrote:
$sql
On Mon, May 19, 2008 at 7:24 AM, Jerry Schwartz
[EMAIL PROTECTED] wrote:
I might not understand what this is doing, but I think it will preferentially
sample the ids that are at the end of a gap.
What don't you understand about the query or the way I described it?
You say you want a flat
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 11:20 AM
To: Jerry Schwartz
Cc: Scott Haneda; mysql@lists.mysql.com
Subject: Re: improving random record selection
On Mon, May 19, 2008 at 7:24 AM, Jerry Schwartz
[EMAIL PROTECTED] wrote:
I might
I posted this a month or so ago, and was helped a little, but I am now
back.
Currently I use select x, y, z from images where (condition) order by
rand() limit 1;
As most know, it is slow, depending on the record set, and what I
compare it to, it can be from one order of magnitude
On Sat, May 17, 2008 at 2:32 PM, Scott Haneda [EMAIL PROTECTED] wrote:
$sql =
SELECT storage_path, image_md5, t.id
FROM images AS t
JOIN
(SELECT CEIL(MAX(id)*RAND()) AS id FROM images) AS x
ON (t.id = x.id)
a random record and then ignore the rest. Lets say i have 2000
records in the table but 5 of them are dupes based on the surname and
postcode, how can I pick one of those 5 at random and return it with
the rest of the table.
Any help would be greatly appreciated.
--
MySQL General Mailing List
zv Green wrote:
Hello all,
What I want to do is select all the records from the table but where
there
are duplicate entries (based on say, the surname and postcode fields)
pick a random record and then ignore the rest.
If you want to pick a random record, you can do ORDER BY RANDOM LIMIT 1
zv Green wrote:
Hello all,
What I want to do is select all the records from the table but where
there
are duplicate entries (based on say, the surname and postcode fields)
pick a random record and then ignore the rest.
If you want to pick a random record, you can do ORDER BY RANDOM
Michael Stassen wrote:
For example, if the selected random id is
missing, we take the next id we find, like this:
SELECT @rand_id:= CAST( 1 + MAX(id)*RAND() AS UNSIGNED) FROM history;
SELECT * FROM history WHERE id = @rand_id LIMIT 1;
That will have a possibly undesired effect. Records that
Michael Stassen wrote:
For example, if the selected random id is missing, we take the next id we
find, like this:
SELECT @rand_id:= CAST( 1 + MAX(id)*RAND() AS UNSIGNED) FROM history;
SELECT * FROM history WHERE id = @rand_id LIMIT 1;
That will have a possibly undesired effect. Records that
PROTECTED]; mysql@lists.mysql.com
Sent: Friday, May 13, 2005 7:48 PM
Subject: Re: Efficiently finding a random record
in() can take millions of arguments. Up to max packet size. Try it :)
Dan Bolser wrote:
On Fri, 13 May 2005, Eric Bergen wrote:
Even better is if you have an integer
: mysql@lists.mysql.com
Sent: Sunday, May 15, 2005 6:42 AM
Subject: Re: Efficiently finding a random record
Hi,
i did the test and agree with you. even with
Select ID from history where id = 1+CAST( rand() * 19 as UNSIGNED)
limit 1;
when testing : select CAST( rand() * 19 as UNSIGNED
: [EMAIL PROTECTED]
To: Gary Huntress [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, May 15, 2005 6:42 AM
Subject: Re: Efficiently finding a random record
Hi,
i did the test and agree with you. even with
Select ID from history where id = 1+CAST( rand() * 19 as UNSIGNED)
limit 1;
when
Eric Bergen wrote:
in() can take millions of arguments. Up to max packet size. Try it :)
True, but several past threads have suggested that performance drops
dramatically when the size of the IN list gets too large. As IN is
equivalent to an equality check for each value in the list, separated
Bergen [EMAIL PROTECTED]
To: Dan Bolser [EMAIL PROTECTED]
Cc: Philip Hallstrom [EMAIL PROTECTED]; Brian Dunning
[EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, May 13, 2005 7:48 PM
Subject: Re: Efficiently finding a random record
in() can take millions of arguments. Up to max packet size
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What is the primary
culprit here?
--
MySQL
At 12:54 PM 5/13/05, Brian Dunning wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What
I have a db of about 300,000 records and when I try to find one random record
like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me that what
I'm doing is somehow inefficient. What is the primary culprit here?
The culprit
more random numbers
and try again.
in() is blazing fast even with thousands of numbers so don't be afraid
to kick a few extra in.
-Eric
Philip Hallstrom wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1
Hallstrom wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What is the primary
culprit
. When you say 'thousands of numbers' do you
mean in the IN or in the column?
-Eric
Philip Hallstrom wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes
- Original Message -
From: Christian Biggins [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, January 14, 2005 12:07 AM
Subject: Selecting a random record from more than 1 table
Hi Guys
I am trying to display 1 random record taken from 2 tables.
I have tried the following
). In that case, please post
your version and maybe someone else can suggest something that would work
for you.
Rhino
- Original Message -
From: Christian Biggins [EMAIL PROTECTED]
To: 'Rhino' [EMAIL PROTECTED]
Sent: Friday, January 14, 2005 11:43 AM
Subject: RE: Selecting a random record
Hi Guys
I am trying to display 1 random record taken from 2 tables.
I have tried the following;
SELECT table1.record1, table1.record2, table2.record1 FROM table1, table2
ORDER BY RAND() Limit 1
With no luck... So now I am trying to use CREATE VIEW but also with no
luck... Can anybody help out
How's that for alliteration in a subject line?
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page load. How do I randomly access
mos wrote:
At 05:08 PM 5/22/2004, you wrote:
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that
I want
to appear at the bottom of the pages of my website. I want them to
come up
randomly
hi,
why its mysql database over random record use?
hi,
why its mysql database over random record use?
39?
-Original Message-
From: tuncay bas [mailto:[EMAIL PROTECTED]
Sent: 15 September 2003 13:32
To: mysql
Subject: random record
hi,
why its mysql database over random record use?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
pls unsubscribe me from this maillist. thanks.
- Original Message -
From: Andy Eastham [EMAIL PROTECTED]
To: Mysql List [EMAIL PROTECTED]
Sent: Monday, September 15, 2003 8:54 PM
Subject: {Scanned} RE: random record
39?
-Original Message-
From: tuncay bas [mailto:[EMAIL
I just checked...
83
On Mon, 15 Sep 2003 13:54:53 +0100, Andy Eastham
[EMAIL PROTECTED] wrote:
| 39?
|
| -Original Message-
| From: tuncay bas [mailto:[EMAIL PROTECTED]
| Sent: 15 September 2003 13:32
| To: mysql
| Subject: random record
|
|
| hi,
|
| why its mysql
I found this:
SELECT * FROM table_name ORDER BY RAND()
Is there a way to weight the random selection so that certain records are
more likely to come up?
It's for a banner exchange program. The idea is to somehow give precedence
to help promote certain sites.
Thanks! =)
-Ed
If you have a field 'weight', you could
SELECT *, RAND()*weight AS r FROM table_name ORDER BY r
(Or you can complicate the expression more :-)
laszlo
Ed Lazor wrote:
Ed Lazor wrote:
I found this:
SELECT * FROM table_name ORDER BY RAND()
Is there a way to weight the random selection so
Dear MySQL masters,
Is there any way to display a random record from a table. If there are no
direct SQL commands can you pls suggest a logic for doing the same.
Details:
There is a table of 200 records. The user must be able to select a record
randomly. Once that record is displayed
You have to have version 3.23 of mysql and then you can add ORDER BY RAND()
to the end of your query.
Alan
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 25, 2018 4:40 PM
To: MySQL
Subject: Random record
Does anyone have any good ideas on how to pull
Does anyone have any good ideas on how to pull a random record? I've been using PHP's
random function to create a random number to pull, but the problem is that if I delete
a record, it could still try to pull it. Is there a better way? I'd really like to
be able to just pull it in the SQL
Check the archives. The answer you seek is there.
Cal
http://www.calevans.com
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 25, 2018 5:40 PM
To: MySQL
Subject: Random record
Does anyone have any good ideas on how to pull a random record? I've been
ryan
- Original Message -
From: "joe" [EMAIL PROTECTED]
To: "MySQL" [EMAIL PROTECTED]
Sent: Sunday, February 25, 2018 5:39 PM
Subject: Random record
Does anyone have any good ideas on how to pull a random record? I've been
using PHP's random function to create
Dear MySQL masters,
Can I select a random record from a table. After doing a query on a table
can i retrieve a record randomly. Is there a way in MySQL to achieve this.
If, can you please send me details.
thanks
Sheni R Meledath
[EMAIL PROTECTED
Check the archives, we had this discussion a few weeks ago and someone came
up with a good solution.
Cal
http://www.calevans.com
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 24, 2001 9:05 AM
To: MySQL Masters
Subject: Random record from
On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I
PROTECTED]
Subject: FW: Selecting a random record
Any idea why I get this error when I try to create this table
on a clean
3.23.30 install on a BSDI box.
This was the output from a mysqldump from version 2.22.32 on a working
database. It will not allow me to recreate my database on the
n
44 matches
Mail list logo