the MySQL docs:
http://dev.mysql.com/doc/mysql/en/string-functions.html
Eamon Daly
- Original Message -
From: "Grant Giddens" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 28, 2005 11:43 AM
Subject: QUERY ordering c
Grant Giddens <[EMAIL PROTECTED]> wrote on 03/28/2005 12:43:09 PM:
> 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
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)
>
> W
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 alw
