> It looks as if you are being over-complex anyway. Isn't what you want > > SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ; > > which picks a single random record.
No, I have to know which is the ID I pick before doing the select (because I splitted my data, and when I access the splitted table I have code like: int table = ((m / 2000000) + 1); String query = "SELECT * FROM PARTITIONED_B_" + table + " WHERE ID=?"; ) Thank you anyway -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]