select * from table where strcol REGEXP "^[[:digit:]]+$" order by strcol
Regards Dan > -----Original Message----- > From: Prospect'In [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 28 February 2002 11:31 a.m. > To: [EMAIL PROTECTED] > Subject: Order by on Alphnumeric > > > sql,query > > Good Day, > I have a varchar field which contains alphanumeric data. > I want to be able to order this field by only the > numeric values in the field. > > help!! > > Rick > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
