mysqlmysql 3.23.41 phpMyAdmin 2.2.3 os :Linux server 2.4.9-31 In order to remove the first character '0' of the field 'number', I want to use the following sql query to select the field from my database.
select right(number, if(locate('0',length(number))=1,length(number)-1,length(number))) as 'no_zero' from mydatabase order by id desc LIMIT 0, 30 when i use the order sub query 'order by id asc',this sql query will take effect , the first character'0' will be removed. when i use the order sub query 'order by id desc',this sql query will take no effect , the first character '0' will not be removed. I think it's a bug. sorry about my poor English,waitting for your letter in reply. --------------------------------------------------------------------- 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