* [EMAIL PROTECTED]
> 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 or
On Fri, 14 Jun 2002, [GB2312] ³Â׿ wrote:
> 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(
