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
