I searched the other lists and couldn't find one that was more appropiate for this
question; if there is, please tell me so :)
I am monitoring networking equipment and so far I'm saving all my data in a MySQL database
(hence an email to this list). I'm using only VARCHARs because the SNMP agent returns only
strings and I didn't find enough a reason for converting the different types of answers,
since most string comparations are donde correctly; I received both text and numbers from
the monitoring tasks and wanted to keep it simple.
However when I execute this select statement I am getting this problem:
select info_oficina,valorSNMP from ultimas_respuestas_snmp where
columna_donde_guardar='USO_CPU_1min' order by valorSNMP desc limit 10;
info_oficina valorSNMP
CSF Desamparados error
Periferica Palmares 4
CSF San Pedro 4
Sucursal Guapiles 4
Periferica Pentagono San Pablo 30
Periferica Tibas 3
Periferica Buenos Aires 3
Sucursal Turrialba 3
Ventanilla Florencia 3
CSF del Sur (Ciudad Neilly) 3
Where info_oficina, valorSNMP are columns, ultimas_respuestas_snmp is my table, etc.
The summary question is:
given a column with the numbers 0 to 99 of type varchar, how can i tell MySQL to order it
as if they were integer values, so that instead of
99,98,97,96,95,94,93,92,91,90,9,89
I'd have
99,98,97,96,95,94,93,92,91,90,89,88
Apparently, CAST() does not have an effect (but feel free to prove me wrong)
Thanks!
Ariel
