List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 11 2000 5:18pm
Subject:Re: String To Integer MYSQL command
View as plain text  
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
Thread
String To Integer MYSQL commandKadir Imamoglu11 Jan
  • Re: String To Integer MYSQL commandJohn Zook11 Jan
  • Re: String To Integer MYSQL commandjcole11 Jan
  • Re: String To Integer MYSQL commandPaul DuBois11 Jan
  • Re: String To Integer MYSQL commandsinisa11 Jan