Re: [PHP] Ordering a text field

> 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 b

[PHP] Ordering a text field

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