Revision history for Perl extension DBD::Sprite.
0.01 Fri Feb 25 13:00:55 2000
update MYTABLE set FIELD1 = '$1' where FIELD2 =~ '(\d+)' This will set FIELD1 to the 1st number found in FIELD2 in the same record. Up to 2 matches for each "where" expression containing "=~" or "!~" may be captured. $1 .. $n correspond to each set of unescaped parenthesis from left to right in the "where" clause.