On Friday, 22. March 2002 10:43, Mickael Bailly wrote: > Hello ! > > I got a table having an auto_increment field, let's say 'id'. tis table > has a varchar field too, let's say 'name'. > > Is there a way to do something like: > > select id, name from table where id in (5,3,7) > > AND that mysql orders the results the way I gave into the 'IN(...)' clause > ?
Hi Mickael, you can use the find_in_set function e.g. select id,name from table where find_in_set (id, "5,3,7"); But you can't order them in the order specified in set. Regards Georg Only for the spam filter: mysql rulez! --------------------------------------------------------------------- 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
