Re: String To Integer MYSQL command

[Paul DuBois]

At 5:12 PM -0600 01-11-2000, Kadir Imamoglu wrote:
>Hi
>
>I use MySQL Server on Linux. I have a field which is string. In this 
>area there is some numbers. I want to convert this field to integer. 
>Because I want to order this numbers. I can't find a command. If 
>somebody help me I will be happy.

Try this:

SELECT str_col + 0 AS s FROM tbl_name ORDER BY s

-- 
Paul DuBois, paul@stripped