I'm running a mysql query with the ORDER BY clause, the problem is that the column that I'm running them on is type tinytext. The data are product numbers, most of which are numbers, but some are like "404R" or whatever else. So if my values are 403, 404R,405, 4150 - the order ends up being: 403 4150 404R 405
Is there any way I can leave these products numbers as text and still order them correctly? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php