Dream.In.Code > Programming Help > Databases

Welcome to Dream.In.Code
	Become an Expert! Join 149,755 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,454 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

MySQL: Select random(unseen) row, quickly

Reply to this topic

Start new topic

MySQL: Select random(unseen) row, quickly

girasquid	17 Feb, 2007 - 11:15 AM Post #1
Barbarbar Joined: 3 Oct, 2006 Posts: 1,294 Thanked: 18 times Dream Kudos: 725 My Contributions	Hello, all. I am working on a project that involves storing data in a MySQL database, that users will randomly see. Each time that a user sees the data, we store the id value for the row of data into another table, so that the user won't see that row again. I know I can select a random row from my first table using this: CODE SELECT * FROM data1 ORDER BY RAND() LIMIT 1 And then I could just use the ID value and keep selecting values until I found one that wasn't stored in seen_data. However, this seems...kludgy, and I'd like to know if anyone has a better idea on how I could do this. Any takers? Thanks, Girasquid
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

skyhawk133	RE: MySQL: Select Random(unseen) Row, Quickly 17 Feb, 2007 - 12:07 PM Post #2
Head DIC Head Joined: 17 Mar, 2001 Posts: 15,262 Thanked: 61 times Dream Kudos: 1650 Expert In: Web Development My Contributions	I believe you could do this: SQL SELECT * FROM data1 WHERE id NOT IN (SELECT id FROM seen_data) ORDER BY RAND() LIMIT 1;
	This Post Was Helpful!

girasquid	RE: MySQL: Select Random(unseen) Row, Quickly 17 Feb, 2007 - 01:15 PM Post #3
Barbarbar Joined: 3 Oct, 2006 Posts: 1,294 Thanked: 18 times Dream Kudos: 725 My Contributions	After a quick test, it's working great. Thanks!
	This Post Was Helpful!

gregoryH	RE: MySQL: Select Random(unseen) Row, Quickly 22 Feb, 2007 - 12:01 AM Post #4
D.I.C Regular Joined: 4 Oct, 2006 Posts: 417 Dream Kudos: 50 My Contributions	QUOTE(skyhawk133 @ 17 Feb, 2007 - 01:07 PM) I believe you could do this: SQL SELECT * FROM data1 WHERE id NOT IN (SELECT id FROM seen_data) ORDER BY RAND() LIMIT 1; Chris Love your work... just beautiful, beautiful....
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 1/8/09 05:57AM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Be Social

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month