Hi all,
I'm executing the follow very simple type of query to select entries from a
list:
"select entryid, entryinfo from mytable where entryid in ('id7', 'id4',
'id2', 'id5')"
and, even though I don't specify any sorting order, MySQL sorts
alphabetically
by the field "entryid" (which happens to be an index), i.e. it returns
+----------+-----------+
| entryid | entryinfo |
+----------+-----------+
| id2 | ... |
| id4 | ... |
| id5 | ... |
| id7 | ... |
+----------+-----------+
I don't want this sorting order; I want the order to be that of the list. Is
there a
way to do this? It appears very simple but I cannot find how.
Thanks for any comments or help,
George
---------------------------------------------------------------------
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
