MySql record fetching

Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

MySql record fetching

This is a discussion on MySql record fetching within the MY SQL forums, part of the Databases category; hello everyone can anyone of you help me find a way to fetch random and unique records from database...

		Geeks Talk > Databases > MY SQL
MySql record fetching

MY SQL MY SQL

LinkBack

Thread Tools

Display Modes

#1 (permalink)

10-03-2009

karda_ruchika karda_ruchika is offline

Junior Member

Join Date: Oct 2009

Location: Gwalior,M.P.

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

karda_ruchika is on a distinguished road

MySql record fetching

hello everyone
can anyone of you help me find a way to fetch random and unique records from database

Sponsored Links

#2 (permalink)

10-06-2009

Lokesh M

Moderator

Join Date: Oct 2005

Posts: 1,037

Blog Entries: 75

Thanks: 3

Thanked 168 Times in 136 Posts

Re: MySql record fetching

You have to make use of RAND() Function

Code:

SELECT field_1, field_2, field_3 FROM `table_name` ORDER BY RAND() LIMIT 0, 10;

« difference between enterprise and community server | Where Clause with Group by and Order by »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 On Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accessing first and Last record from mysql recordset	kunal.mathur	JSP	1	07-09-2009 09:23 AM
Join fields from two files record-by-record	diptisaini	MainFrame	0	06-16-2009 10:23 PM
Join fields from two files record-by-record by using utility in jcl	diptisaini	MainFrame	0	06-09-2009 12:24 PM
Record GUI Script and Record Session icons are always disabled	Geek_Guest	Rational Robot	1	06-01-2007 09:01 AM
Fetching datas from two cursors	gvvskumaran	Oracle	7	02-22-2007 01:23 AM

All times are GMT -4. The time now is 09:56 PM.

MySql record fetching

MySql record fetching

Similar Threads