Re: changing datatypes in the query
| From: | Matt Babineau | Date: | Tue, 26 Aug 2003 16:09:18 +0000 |
| Subject: | Re: changing datatypes in the query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30101@lists.php.net to get a copy of this message | ||
I think I answered my own question, I used CAST() to set the type in the
ORDER BY statement.
cast(s11.data as unsigned)
Thx to me!
Matt
On Tue, 2003-08-26 at 11:21, Matt Babineau wrote:
> Hi all-
>
> Tough question (I think). I am pulling some numbers out of a data base,
> currently they are stored in a blob. When I try to "order by user_hits
> desc" it does a text ordering, not a numerical ordering. Is there a way
> to get it to do a numeric ordering?
>
> Thanks,
> Matt