View source for Ordinare un campo VARCHAR come un numerico in Mysql

← Ordinare un campo VARCHAR come un numerico in Mysql

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.

Aggiungere 0 al campo che si usa per l'ordinamento:

 SELECT * FROM table ORDER BY (varchar_field + 0.0)

==Riferimenti==
*[http://lists.mysql.com/mysql/202201 MySQL Lists: mysql: Re: making varchar field to act like numeric field]

Return to Ordinare un campo VARCHAR come un numerico in Mysql.

Retrieved from "https://kb.rvmgroup.it/index.php/Ordinare_un_campo_VARCHAR_come_un_numerico_in_Mysql"