- - Code, Content, and Presentation
- -- Databases
- ---- Mysql - Converting varchar field to tinyint
rocknbil - 4:01 pm on May 16, 2011 (gmt 0)
You probably want decimal so you don't lose your fractionals. Decimal is a lot easier to manage than float.
alter table yourtable change rating rating decimal(12,2) not null default '0.00';
That should order them properly, unless I'm missing something.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4312723.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com