In the last episode (Oct 16), Michael Winston said:Is there any way to do "natural sorting" in MySQL? That is: Chapter 1 Chapter 2 Chapter 10
instead of
Chapter 1 Chapter 10 Chapter 2
If not, are there any plans for this feature in future releases? Would be pretty helpful...
You can easily enough write a UDF that zero-pads all numbers in a string to N digits, which would let you do "SELECT * FROM mytable ORDER BY dwim_sort(textfield,5)"
"Easily enough"? ha ha. I've looked at the example UDF and realized that I am in over my head on that one. Still, I wasn't even aware of UDFs, so thanks.
Anyone done this already or know of a good repository of UDFs? Google didn't provide anything useful...
Thanks, Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
