select random record - CodingForums.com

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > :: Server side development > MySQL > Other Databases
select random record

Before you post, read our: Rules & Posting Guidelines

Enjoy an ad free experience by logging in. Not a member yet? Register.

03-16-2005, 06:37 PM	PM User \| #1
esthera Senior Coder Join Date: May 2004 Posts: 1,432 Thanks: 14 Thanked 0 Times in 0 Posts	select random record I have the following code select top 1 * from users how can I instead of selecting the top just select a random record?

04-02-2005, 04:09 AM	PM User \| #2
DigitalBliss Regular Coder Join Date: Mar 2005 Location: United States Posts: 271 Thanks: 0 Thanked 0 Times in 0 Posts	order by rand() __________________ -the core- -the structure-

Bookmarks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT +1. The time now is 05:22 AM.