Rocinante's Tech Stuff
Rocinante team member comments on issues affecting their daily coding.
Tuesday, December 19, 2006
Sort powers in MySQL
Posted by
Cristobal Tello
1 comment:
We are using the ORDER BY CAST (field AS SIGNED) clause to sort the results by ‘power’ field. But it’s wrong!!
The way for sort ‘power’ it’s: ORDER BY `Power`+0
Strange… but works fine!!!
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
