I have a little question I have a big table ( a lot of fields) whitout keys In order to got a list sorted by the time of insertion I build a sequential acces with this syntax
SELECT * FROM table WHERE NUMERO='248' ; It's was perfect But now I woulf like got this list with inverse order Sure I can put a new filad with the number of row but It's not so "elegant" :-) I succed to got in random order by this syntax SELECT * FROM table WHERE NUMERO='248' order by RAND(); And i am sure that we can find a solution for my pb/ SELECT * FROM table WHERE NUMERO='248' order by rowcount() DESC; I cann't succeed to find the function for rowcount() !!! count() ? row_count() ? Somebody can help me SOS Sorry for my english Dorilys -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]