[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