Sorting Fields with varchar and Int
| From: | PHPWIN | Date: | Wed, 11 Oct 2000 11:23:47 +0000 |
| Subject: | Sorting Fields with varchar and Int | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-3166@lists.php.net to get a copy of this message | ||
Hi
Does anyone know how to sort these columns in MySql from
+------+
I 1b I
+------+
I 1c I
+------+
I 2b I
+------+
I 1a I
+------+
I 2a I
+------+
to this
+------+
I 1a I
+------+
I 1b I
+------+
I 1c I
+------+
I 2b I
+------+
I 2a I
+------+
if the fields are varchar()
cheers
Xon