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 Quote 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 Quote 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? Quote 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; Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.