28rain Posted September 20, 2009 Share Posted September 20, 2009 I accidently set the vale of my price column to be a tinytext, but i want sql to be able to order the values by price when I display them. How can I order by int value? Thanks Link to comment https://forums.phpfreaks.com/topic/174889-solved-order-char-by-int-value/ Share on other sites More sharing options...
RussellReal Posted September 20, 2009 Share Posted September 20, 2009 just change the field type Link to comment https://forums.phpfreaks.com/topic/174889-solved-order-char-by-int-value/#findComment-921673 Share on other sites More sharing options...
28rain Posted September 20, 2009 Author Share Posted September 20, 2009 How?? Ive been looking around (briefly I admit) but it didnt seem possible? Link to comment https://forums.phpfreaks.com/topic/174889-solved-order-char-by-int-value/#findComment-921678 Share on other sites More sharing options...
RussellReal Posted September 20, 2009 Share Posted September 20, 2009 ALTER TABLE table MODIFY price INT NOT NULL; Link to comment https://forums.phpfreaks.com/topic/174889-solved-order-char-by-int-value/#findComment-921682 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.