poolhustler86 Posted January 15, 2007 Share Posted January 15, 2007 Hey Everyone...I have a question reguarding how to sort mysql results from a table.I have a table with a column (varchar) named prod_size_color...example data...80mm x 80mm x 11.5mm - White115mm x 80mm x 11.5mm - WhiteEverytime i sort it by the prod_size_colour the 115mm x 80mm x 11.5mm - White appears first... the only way to stop that happening is to place a 0 infront of 80mm x 80mm x 11.5mm - White...Anyway I can sort it without placing 0 infront? Quote Link to comment Share on other sites More sharing options...
Psycho Posted January 15, 2007 Share Posted January 15, 2007 If all records in that table have three dimension characteristics, Then create three columns in the table for each size parameter and only put the numerical value (i.e. not the "MM") in those fields. You could then easily do a numerical sort on the first value, thent he 2nd and the third. You wouldn't need the current column with all three values as you could simply concatenate the three vales with the "mm" when youdisplay them. Quote Link to comment Share on other sites More sharing options...
sasa Posted January 15, 2007 Share Posted January 15, 2007 try order by (prod_size_color + 0) Quote Link to comment 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.