say $dbh->do(q{
UPDATE columns_settings
SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '')
SET columnname = SUBSTRING(columnname,LOCATE("_",columnname)+1)
WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table")
});
say_success( $out, "Column names renamed" );
-