Eamon Daly wrote:
> Easy enough. Get the numeric part via CONVERT, then get the
> rest of the string from the length of the numeric part, plus
> one:
>
> SELECT
> tag,
> @num := CONVERT(tag, SIGNED) AS num_part,
> SUBSTRING(tag, LENGTH(@num) + 1) AS rest_of_string from tags;
> +--------+----------+----------------+
> | tag | num_part | rest_of_string |
> +--------+----------+----------------+
> | 1foo | 1 | foo |
> | 23bar | 23 | bar |
> | 234baz | 234 | baz |
> +--------+----------+----------------+
> 3 rows in set (0.00 sec)
>
> ____________________________________________________________
> Eamon Daly
Unless the string starts wit a '0'.
>
>
>
> ----- Original Message ----- From: "dixie" <dixie@stripped>
> To: "MySQL" <mysql@stripped>
> Sent: Friday, April 22, 2005 6:18 PM
> Subject: extract numeric value from a string.
>
>
>> Hi at all, I've this necessity.
>> In a table I've a field popolated by a string where the first (not
>> costant lenght) part are number and the second part caracter.
>> I want extract, in other field, the first part and the second in another
>> field.
>> There is a function to obtained it?
>>
>> Tks in advance
>>
>> Paolo
>> --
>> dixie <dixie@stripped>
>
>
>
