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
