Re: Ordering rows whit a select from where in ( exp )

[=?ISO-8859-1?Q?Johan_H=F6=F6k?=]

Hi Adrian,
you can do
SELECT field_name FROM meta WHERE id IN
('13','11','7','8','9','10','12')
ORDER BY FIELD(id,'13','11','7','8','9','10','12')
/Johan
Adrian wrote:
 

Hi everyone, 

 

 

         Here is my issue:   

 

         I have this Query  :     SELECT field_name FROM meta WHERE id IN
('13','11','7','8','9','10','12')
 

         I want the rows to be display in the same order as the in list of
ids.Any ideas? Should I use order by? Whit witch option ? 

 

  

  Thanks for your help.
 

  Adrian.  

 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]