I thought of a new feature... XSLT's "position()"-like functionality in the new releases of MySQL.
position(), in XSLT, returns position of the node in the document tree. In MySQL it would return position of the record in the returned result set (from SELECT query): Example: SELECT POSITION(), first_name, last_name WHERE last_name LIKE "a%"; Return value might be: 1 | Alpha | Beta | 2 | Aqua | Gamma | ... etc.. By default numbering would start with 1. But it can be alterled by passing argument to POSITION(). I believe it is an exciting feature. sherzod --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php