Ahhh...I see now. I'm still in MySQL 3.23.54. Thanks anyways! > -----Original Message----- > From: Cabanillas Dulanto, Ulises [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 07, 2003 2:52 PM > To: mysql > Subject: RE: order by question > > > I execute the SELECT and it works!. I have MySQL 4.0.4 > > Regards, > Ulises > > -----Mensaje original----- > De: motorpsychkill [mailto:[EMAIL PROTECTED] > Enviado el: Jueves 7 de Agosto de 2003 04:43 PM > Para: mysql > Asunto: RE: order by question > > > -----Original Message----- > > From: Roger Baklund [mailto:[EMAIL PROTECTED] > > Sent: Thursday, August 07, 2003 10:54 AM > > To: mysql > > Cc: motorpsychkill > > Subject: Re: order by question > > > > > > * motorpsychkill > > > SELECT * FROM kf_gallery WHERE gallery_id IN ( 3, 1, 2 ) > ORDER BY ? > > > > > > What I'm trying to do is get the results in the order specified > > > in the "IN" > > > clause, i.e. (3, 2, 1). Is this possible? (I'm having trouble > > searching > > > the mail archives). Thanks! > > > > Use the FIELD() function: > > > > SELECT * FROM kf_gallery > > WHERE gallery_id IN ( 3, 1, 2 ) > > ORDER BY FIELD(gallery_id, 3, 1, 2) > > > > HTH, > > > > -- > > Roger > > Thanks Roger, but that didn't seem to work. It still gave me the results > ASC, i.e. by gallery_id 1, 2, 3. Anyone else? :) >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]