[linux-programlama] Re: MySql Order By 4.0.2+ sürümlerde CONVERT

• Previous message: tayfun_yurdagul@vizyonsoft.com: "[linux-programlama] Re: php ile oracle"
• In reply to: Alper Oguz: "[linux-programlama] Re: MySql Order By"

Yeni s=FCr=FCm=FC kullanan arkada=FElar i=E7in hat=FDrlatal=FDm

MySQL reference manual:
D.1.4 Changes in release 4.0.2 (01 Jul 2002)
Added CAST() and CONVERT() functions. The CAST and CONVERT functions are
nearly identical and mainly useful when you want to create a column with =
a
specific type in a CREATE ... SELECT statement. For more information, =
read
section 6.3.5 Cast Functions.=20

SELECT sayi, diger, oburu FROM TABLE ORDER BY CONVERT(sayi, SIGNED) ASC;

H=FCseyin ASLIT=DCRK

-----Original Message-----
From: linux-programlama-bounce@liste.linux.org.tr
[mailto:linux-programlama-bounce@liste.linux.org.tr] On Behalf Of Alper =
Oguz
Sent: Thursday, October 02, 2003 12:25 PM
To: Mustafa Karakaplan
Subject: [linux-programlama] Re: MySql Order By

Merhaba,

01.10.2003, 21:46, Mustafa Karakaplan wrote:
MK> SELECT sayi,diger,oburu FROM TABLE ORDER BY sayi+0 ASC; seklinde=20
MK> olabilir. varchar a bir sayi eklediginizde mysql sonucu sayiya=20
MK> ceviriyor.

Hocam hani derler ya, bin yasayin. :)

--
 Alper O=F0uz    alperliste@showtv.com.tr

• Previous message: tayfun_yurdagul@vizyonsoft.com: "[linux-programlama] Re: php ile oracle"
• In reply to: Alper Oguz: "[linux-programlama] Re: MySql Order By"