hello,
Is it possible to use a Regular expression to update a field like inperl (s/T/t/)ie :update table set name=($1) where name ~* '.*(phe).*'substitute using a grouping function $1 is in fact 'phe'.
It should be really interesting and powerfull !