in reply to Can I move a substitution string into a constant?
$stmt =~ s/TABLE_NAME.//g; # doesn't work
Just to note that the dot might cause major problems there, as it matches "any character".
If your table name is 'customers' and you have another table called customersummary, then you'll replace the first letter of that too, so if you're changing 'customers.' to 'buyers.', it will also change 'customersummary' to 'buyers.mmary'.
($_='kkvvttuubbooppuuiiffssqqffssmmiibbddllffss') =~y~b-v~a-z~s; print
|
|---|