| 14 |
SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '') |
14 |
SET columnname = SUBSTRING(columnname,LOCATE("_",columnname)+1) |
| 15 |
WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table") |
15 |
WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table") AND (columnname LIKE 'holdings_%' OR columnname LIKE 'otherholdings_%') |
| 18 |
say_success( $out, "Column names renamed" ); |
18 |
say_success( $out, "Column names renamed" ); |