RE: Order by list?

2002-03-12 Thread John Lodge
George, What I would do is include an auto_increment column in the table and order the select queries by that column. I don't know of a way of doing what you want with existing data. John Lodge -Original Message- From: George Marnellos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12,

Re: Order by list?

2002-03-11 Thread Paul DuBois
At 20:00 -0800 3/11/02, George Marnellos wrote: >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 sor