[Mysql-list] A help with a random query

Pablo Antonio Caraballo Coll pablo@udo.edu.ve
Mon, 19 Jan 2004 15:12:08 -0400 (VET)


I would really appreciate your help about this:

I have a table with a lot of rows and I would like to select only 20 rows
every time (I can use LIMIT 20). But I want this select to be random, that
is every time that I do a select I would like to get 20 differents rows.
Is this possible? How?

Another Q:
Is it a possible to select a row but a unique identifier?, like in
ORCLE/MSQL using rowid.

By the way, I am using MySQL 3.23.43.

-- 
Pablo Antonio Caraballo Coll
Coordinador de Teleinformatica
CCAI (Cisco Certified Academy Instructor): 5287806302510
CCNA (Cisco Certified Network Associate): CSCO10313814
Rectorado - Universidad de Oriente
Cumana - Estado Sucre, Venezuela
tlf.:  (58293) 430-1107/(58414) 840-3147