Ordering a text field
| From: | drparker at clam dot rutgers dot edu | Date: | Thu, 14 Nov 2002 21:21:47 +0000 |
| Subject: | Ordering a text field | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-124500@lists.php.net to get a copy of this message | ||
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?