RE: [PHP-DB] re: mysql ORDER BY problems
| From: | Dwight Altman | Date: | Mon, 19 Jun 2006 14:24:29 +0000 |
| Subject: | RE: [PHP-DB] re: mysql ORDER BY problems | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42092@lists.php.net to get a copy of this message | ||
I believe I did this one time without changing the database schema; simply
by just putting the type in the ORDER BY clause.
Something like
ORDER BY BINARY numbers ASC
or maybe
ORDER BY CAST(numbers AS BINARY) ASC
Regards,
Dwight
> -----Original Message-----
> From: J. Alejandro Ceballos Z. -JOAL-
> [mailto:buzon@alejandro.ceballos.info]
> Sent: Sunday, June 18, 2006 7:01 PM
> To: php-db@lists.php.net
> Cc: rob@fiberuplink.com
> Subject: [PHP-DB] re: mysql ORDER BY problems
>
> are they defined as integer or varchars (string)?
>
> try
> a) exchange field definition varchar / integer
> b) order by length(number) and later by number
>
> --