Hello, Assume nothing. Use ORDER BY or re-think your approach to the problem.
MarkP On Mon, 28 Mar 2005 09:43:09 -0800 (PST), Grant Giddens <[EMAIL PROTECTED]> wrote: > Hi, > > If I do a query like: > > SELECT prodname, price FROM prod_table WHERE sku in > ($sku1, $sku2, $sku3, $sku4) > > Will my results always be ordered in $sku1, $sku2, > $sku3, $sku4 order? I can't really do a ORDER BY > prodname or price here. > > I just want to make sure that that this type of query > will always return the results in $sku1, $sku2, $sku3, > $sku4 order. > > Thanks, > Grant > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Mark Papadakis Head of R&D Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]