have you try using the datatype YEAR for you table field/column ?
Mickalo
----- Original Message -----
From: "John Berman" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, February 19, 2007 11:45 AM
Subject: Year - Field type
Hi
Using mysql4
Sure this is an easy one a field in my dbase is year of birth, its always a
4 digit number, for some reason Im failing to sort by the field in my
results, it was originally a varchar field so I updated it to int but still
no luck. Pointers appreciated.
Regards
John Berman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
