Hi, I wonder if something like in perl is possible:
data in rows: 1) a12345xb54321x 2) b54321xa12333x I want to extract b(number) and store into another table. In perl this would work with pattern matching (reg.expressions) like: $data =~ s/.*?b(.*?)x.*?/$1/; $data_b = $1; so, reg.expressions in MySQL also works as I know, but how could I get the "$1" to go further and store a substring of the hit into another table? Regards, Reiner --------------------------------------------------------------------- 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