Test USER wrote:
Hi again :)
The table contains a column named value and is in the format varchar(255).
This column contains specifications for different computer products.
There is also a id column so i know which product it belongs to.
value(varchar)
80
17"
1024x768
USB
DiVX
For example, the first value 80 tells me with som joins that the product maxtor
diamondmax has 80Gb capacity. And that a Philips DVD-player supports DiVX for
the last value in this example.
Now i want to select all harddrvies with a capacity greater or equal to 80.
Doing a "select value from tbl where value >=80 order by value DESC" will give
some unexpected results.
If you have 80, 120, 250 in the database the result will be:
80
250
120
I don't really know how to solve this other than to use CAST(value as SIGNED).
Maybe i could rebuild the database but i don't know how a good databasedesign
for this would look like :)
Is the ordering your only concern? Your value column is a string, so your
results are ordered alphabetically rather than numerically. If all you want is
numeric ordering, you need to tell mysql to treat value as a number in the order by:
SELECT value FROM tbl WHERE value >=80 ORDER BY value+0 DESC;
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
