Posted by Jeff on 11/09/06 15:40

I have a text field (MySQL) that contains integers. Without altering
the table, I'd like to order the results numerically rathjer that
alphanumerically.

ie:
1 2 3 4 5 6 7 8 9 10

rather than 1 10 2 3 4 5 6 7 8 9

I'm unsure of the select syntax.

Jeff

• Next in forum: Error restoring SQL database
• Prev in forum: select * where anyfield in anytable=$SEARCHFOR
• Thread view: casting an order

[Reply to this message]